Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 118
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Asynchronous call (macro) Rodrigo Ferreira Excel Discussion (Misc queries) 1 August 29th 07 07:41 PM
Converting a Access routine into an Excel macro? turtle[_2_] Excel Discussion (Misc queries) 2 February 21st 07 06:38 PM
macro call Steve Excel Discussion (Misc queries) 12 August 25th 06 04:27 AM
How to keep a Variable alive after a Call to Sub Routine Dennis Excel Discussion (Misc queries) 2 July 27th 05 10:57 PM
How to call a macro in an XLA add-in Peter Laman Excel Discussion (Misc queries) 1 March 10th 05 05:40 PM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"