Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Limitations
I have a macro that has a limitation of 5000 lines. Is it possible to create
a larger macro (greater than 5000 lines) ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Limitations
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 "Cinderella" wrote: I have a macro that has a limitation of 5000 lines. Is it possible to create a larger macro (greater than 5000 lines) ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Limitations
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... ;-) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Cinderella" wrote: I have a macro that has a limitation of 5000 lines. Is it possible to create a larger macro (greater than 5000 lines) ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro limitations | Excel Discussion (Misc queries) | |||
Tab Name Limitations | Excel Discussion (Misc queries) | |||
Limitations of auto-open (xlstart) macro | Excel Programming | |||
Macro as alternative to limitations of data table... | Excel Programming | |||
Limitations in UDF:s | Excel Programming |