ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 macros - how to merge 5 macros together into one (https://www.excelbanter.com/excel-discussion-misc-queries/183985-excel-2007-macros-how-merge-5-macros-together-into-one.html)

Sue

Excel 2007 macros - how to merge 5 macros together into one
 
i have several macros i want to put together as one macro. How do I do this
--
Sue

Otto Moehrbach[_2_]

Excel 2007 macros - how to merge 5 macros together into one
 
You will find it easier to read, troubleshoot, and change the macros if you
leave them as separate macros. But the choice is yours. You can merge all
the macros by simply pasting all the code together but you have to be sure
that the code still makes sense.
Or you can leave them as separate macros and run them from one macro, like
this:
Sub MainMacro
Call ThisMacro
Call ThatMacro
Call TheOtherMacro
End Sub
HTH Otto
"Sue" wrote in message
...
i have several macros i want to put together as one macro. How do I do this
--
Sue





All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com