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 December 27, 2022 - Mar 7, 2011 at 09:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 7, 2011 at 09:40 AM
Related:
- Macro to format cells
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Excel macro to create new sheet based on value in cells - Guide
- How to format hp laptop - Guide
- Samsung format code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
