Sub Routine Call From a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I run a macro from within a macro? I have written a very long maro and
I get the erro telling me the procedure is too long. I believe I need to cut
the long macro into several shoter ones but don't know haw to call these
separate macros from the main one.
 
Hi
If you have broken up the macro into smaller ones simply call the macro by
name.
If your smaller macro is called Sub Smaller() for instance, simply put the
word smaller at the location you want it to run in the main macro

HTH
Michael M
 
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

Visual Basic sub routine command?? 1
Link Macros Excel 2007 4
Exit a Procedure from a Sub within a sub 5
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
How to assign PRINT option to execute a macro 3
Adding Quote Marks To A Very Long Column. How, Please ? 1
Pasting cell contents into a macro 1
Macro Help 6

Back
Top