As I understand what you want to do, it can't be done.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sergey_vba"
wrote
in message
...

I have complicated code in which two procedures call each other
many
times (without ending). This cycle may last quite long
depending on the
value entered by user.

The sub will stop under certain conditions, but some times
"calls
stack" memory is not enough and I get "out of stack error".

So when code "jumps" from Sub1 to Sub2, I'd like to End Sub1
from
Sub2.

Thank you,
Sergey




In general, VBA will only execute one procedure at a time - if
you
call
another sub or function, execution of the first suspends until
the
one you
called is done. So I am not clear on what you want to do -
please
give more
details.

"Sergey_vba" wrote:


Hi all,

how can I end one procedure from another?

Thank you,
Sergey


--
Sergey_vba


--
Sergey_vba
------------------------------------------------------------------------
Sergey_vba's Profile:
http://www.excelforum.com/member.php...o&userid=24437
View this thread:
http://www.excelforum.com/showthread...hreadid=380462