ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sub Routine Call From a Macro (https://www.excelbanter.com/excel-discussion-misc-queries/165341-sub-routine-call-macro.html)

D. Jones

Sub Routine Call From a Macro
 
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.

Michael M

Sub Routine Call From a Macro
 
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

"D. Jones" wrote:

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.



All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com