Macros

[mulehead]

How do you run two macros in series. I have to do this because a macro
exceeded 64k and had to be split into two macros.

 

[Gary''s Student]

Sub InSeries()
Call Macro1
Call Macro2
End Sub

 

[Per Jessen]

Hi

Sub Macro1()
YourCode
Call Macro2
End Sub

Sub Macro2
Your Code
End Sub

Regards,
Per

 

[mulehead]

Thank you Per, I will try this!

Hi

Sub Macro1()
YourCode
Call Macro2
End Sub

Sub Macro2
Your Code
End Sub

Regards,
Per

 

[mulehead]

Thanks Gary, I will try your suggestion!

Sub InSeries()
Call Macro1
Call Macro2
End Sub

 

[mulehead]

Gary, It works perfectly, thanks again.

Sub InSeries()
Call Macro1
Call Macro2
End Sub