Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey guys, I'm writing a simulator that uses about a dozen different
procedures. In each procedure I have an Application.Run that sends the compiler to a different procedure. When I run the macro, after awhile, I get a "Run-Time error'28' Out of stack space". I think this comes because I've nested to many procedures. I also don't want to return to the old procedure after completing the new one. So my question: Is there any way to end the old Sub immediately after transferring to the new one? And will the variables remain intact if they are declared as public in a separate module? If my question is a little confusing I'll clarify if necessary. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop a Procedure from another procedure | Excel Discussion (Misc queries) | |||
How to jump from a Form procedure to a Workbook or Module procedure? | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming |