executing a macro within another

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

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

Brian
 
Hi Brian,

Try something like:

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

'Your code

Call Macro2

End Sub
'<<=============
 
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)
 
How easy it is if you are knowledgeable. Thank you Norman and Bob.

Brian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Editing a macro which is within another macro. 3
Asynchronous call (macro) 1
VB code for running a macro 3
Stop Command Question 4
Executing a macro from a cell 2
Macro inside another macro? 3
Simple Macro 4
Menus in xlmenubar 5

Back
Top