We help IT Professionals succeed at work.

How can I get various macros to run in sequence in Excel?

I have 5 macros in one Excel spreadsheet.
I need them to run on after another, as if it was one large script.

Is this possible, or possible to combine the scripts so that one runs first, then it goes to the next and so forth?
Comment
Watch Question

"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
All you need is another sub doing that:
Public Sub CallAll()
   Macro1 Param1, Param2
   Macro2 Param1
End Sub

Open in new window

or, if you prefer the function/method syntax:
Public Sub CallAll()
   Call Macro1(Param1, Param2)
   Call Macro2(Param1)
End Sub

Open in new window

Author

Commented:
The first example worked.