-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
Yes, you can create a Macro to do the Formatting that you like.
For something like this, all you need to do is to turn on the Macro Recorder, and record yourself performing the formatting steps you desire. When you are finished, stop Recording.
This should give you most (if not all) of the code you need.
Note, when recording this Macro, I would recommend saving it to your Personal Macro Workbook. That way, it will always be available to you whenever you have Excel open on that computer.
So when you open your next file, you simply go to the list of Macros and run it.
Yes, you can create a Macro to do the Formatting that you like.
For something like this, all you need to do is to turn on the Macro Recorder, and record yourself performing the formatting steps you desire. When you are finished, stop Recording.
This should give you most (if not all) of the code you need.
Note, when recording this Macro, I would recommend saving it to your Personal Macro Workbook. That way, it will always be available to you whenever you have Excel open on that computer.
So when you open your next file, you simply go to the list of Macros and run it.
Upvote
0
Similar threads
- Question
- Question
