Macro to format cells
Closed
Raji85
Posts
1
Registration date
Monday March 7, 2011
Status
Member
Last seen
March 7, 2011
-
Mar 7, 2011 at 09:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 7, 2011 at 09:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 7, 2011 at 09:40 AM
Related:
- Macro to format cells
- Excel date format dd.mm.yyyy - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Format factory - Download - Other
- Run macro when cell value changes - Guide
- Spell number in excel without macro - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Mar 7, 2011 at 09:40 AM
Mar 7, 2011 at 09:40 AM
Hi Raji85,
Try recording a macro and see if that works for you.
First save your file.
Hit the record button (top menu > extra > macro > record macro) make all the actions you want, stop recording.
Open VBE (alt+F11), look for module1, copy code, reload file, paste code in VBE, run code and see if you get the desired result.
Post back, if you get suck somewhere.
Best regards,
Trowa
Try recording a macro and see if that works for you.
First save your file.
Hit the record button (top menu > extra > macro > record macro) make all the actions you want, stop recording.
Open VBE (alt+F11), look for module1, copy code, reload file, paste code in VBE, run code and see if you get the desired result.
Post back, if you get suck somewhere.
Best regards,
Trowa