How do I split up a macro procdure that is too large?

T

Triggman

I am writing a macro and when I ran it there was an error that said that it
was too large and to split into smaller procedures. How do I do this?
 
B

Bob I

Divide it into 2 macros by locating a suitable break point in the macro
and splitting it there. In other words stop "writing your macro" about
half way, and then start a second macro to finish what ever you want it
to do.
 
T

Triggman

I have tried this. I have a button on the toolbar setup to run the macro and
it will only let me assign one macro to that button.
 
B

Bob I

Then create a "third" Macro to run the other two in order, or Start the
second macro from the end of the first. Or.......
 

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

Top