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?
Who is Participating?
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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

100questionsAuthor Commented:
The first example worked.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.