Macros
 

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.

Macros
 

Sub InSeries()
Call Macro1
Call Macro2
End Sub
--
Gary''s Student - gsnu200785


"mulehead" wrote:

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.

Macros
 

Hi

Sub Macro1()
YourCode
Call Macro2
End Sub

Sub Macro2
Your Code
End Sub

Regards,
Per
"mulehead" skrev i meddelelsen
...
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.

Macros
 

Thank you Per, I will try this!

"Per Jessen" wrote:

Hi

Sub Macro1()
YourCode
Call Macro2
End Sub

Sub Macro2
Your Code
End Sub

Regards,
Per
"mulehead" skrev i meddelelsen
...
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.

Macros
 

Thanks Gary, I will try your suggestion!

"Gary''s Student" wrote:

Sub InSeries()
Call Macro1
Call Macro2
End Sub
--
Gary''s Student - gsnu200785


"mulehead" wrote:

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.

Macros
 

Gary, It works perfectly, thanks again.

"Gary''s Student" wrote:

Sub InSeries()
Call Macro1
Call Macro2
End Sub
--
Gary''s Student - gsnu200785


"mulehead" wrote:

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.