Macro Limitations

C

Cinderella

I have a macro that has a limitation of 5000 lines. Is it possible to create
a larger macro (greater than 5000 lines) ?
 
J

Joel

A macro really shouldn't be more than 200 to 500 line. Yo ushould make
multiple subroutines and call one from another


sub main()


call sub1()
call sub2()
call sub3()
end sub

sub sub1()

end sub

sub sub2()

end sub

sub sub3()

end sub
 
W

Wigi

You're probably copy-pasting analogous code over and over again.

Try to avoid that.

Try to group commands that reappear into another procedure, that you call in
your main procedure. If you want, you can use parameters in these procedures,
if some things are just "a little be different".

I know this is rather vague, but so is your question... ;-)
 

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