Running A Sub Routine

To run another macro from within a macro you need to use the Call statement.

Sub Macro1()
Msgbox("This is Macro1")
Call Macro2 'This calls for Macro2 to run
End Sub