End a procedure from a different procedure
- From: ajserfaty@xxxxxxxxx
- Date: Sat, 24 Nov 2007 11:47:19 -0800 (PST)
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
.
- Follow-Ups:
- Re: End a procedure from a different procedure
- From: Héctor Miguel
- Re: End a procedure from a different procedure
- Prev by Date: Re: round time in column to nearest half hour
- Next by Date: Re: Exit Sub not exiting
- Previous by thread: How to do bit manipulation in VBA?
- Next by thread: Re: End a procedure from a different procedure
- Index(es):
Relevant Pages
|