executing a macro within another

[brian]

How can I call up macro1 to execute it inside macro2? Thanks for help.

Brian

 

[Norman Jones]

Hi Brian,

Try something like:

'=============>>
Public Sub Tester()

'Your code

Call Macro2

End Sub
'<<=============

 

[Bob Phillips]

Sub macro2()

Call macro1

End Sub

If macro1 has arguments,

Call macro1(Param1, param2)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[brian]

How easy it is if you are knowledgeable. Thank you Norman and Bob.

Brian