Macro to format cells
Closed
Raji85
Posts
1
Registration date
Monday 7 March 2011
Status
Member
Last seen
7 March 2011
-
7 Mar 2011 à 09:27
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 7 Mar 2011 à 09:40
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 7 Mar 2011 à 09:40
Related:
- Macro to format cells
- Dvi format - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- How to change date format in excel - Guide
- Hp usb disk storage format tool - Download - Storage
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
7 Mar 2011 à 09:40
7 Mar 2011 à 09:40
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