Excel 2007 macros - how to merge 5 macros together into one

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

i have several macros i want to put together as one macro. How do I do this
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros Doubt 1
Excel 2007: Help creating a macro that will run Solver? 3
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Run a Macro at a certain time 2
personal.xlsb not loaded when excel is called by 3rd party applica 1
Macro security in 2007 5
Excel TWO Instances of Excel One watching Other 3
2003 xla Add In Macro convert to 2007? 3

Back
Top