run two Macros consecutively

**Hassan1977** · 09-03-2013, 04:58 AM

Hello

I am trying to run two Macros one after the other, I have used the following

  Sub Main()

Macro1

Macro2

End Sub

but it doesn`t work as Macro2 is sheet based not module based ..

any way around this ?

Thanks

**Andy Pope** · 09-03-2013, 05:08 AM

  Sub Main()

Macro1

Sheet1.Macro2

End Sub

Include the sheet codename

**Hassan1977** · 09-03-2013, 10:35 AM

I have tried it but I am getting an error ..

Sub RefreshInsert()
Refresh
Sheets("All Orders").InsertWhseRegion
End Sub

Any ideas where I went wrong ?

**Andy Pope** · 09-03-2013, 10:38 AM

That is the sheets name where as you need to use it's code name. You can check the VBA project for sheets code name, the one NOT in brackets.

Re: run two Macros consecutively