![]() Here is the code generated to change the font size to point 22: With Selection.Font. The Macro Recorder can be excessive, and it would be a good idea to simplify this macro by deleting irrelevant code. ![]() For example, although you changed the font size to point 22, Excel created code that set many other font-related properties. You may be surprised by the amount of code that’s generated by simple commands from the Macro Recorder. ![]() Once you’ve recorded your macro, you can view the code that you generated: Choose Developer tab ->Code sub-tab -> Macros -> Select your macro name -> Step Into
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |