exit sub
 

Is there a way to exit 2 subs if 1 has called the other. eg:

Sub 1
code......
code.....(if criteria met then)
Sub2
Code...
End sub

Sub 2
Code....
exit sub(this sub and sub1 if certain criteria not met)
else continue
code
end sub
I know I could set a variable to true or false, but was wondering if
there was a way to just exit all subs/macros.
Regards Robert

exit sub
 

The quick answer is no.

Another method:

You could have an error handler in only the topmost sub and raise an error
in the lowest sub.

another is to make the second sub a function and react to the returned value
(similar to what you spoke of).

--
Regards,
Tom Ogilvy



"RobcPettit" wrote:

Is there a way to exit 2 subs if 1 has called the other. eg:

Sub 1
code......
code.....(if criteria met then)
Sub2
Code...
End sub

Sub 2
Code....
exit sub(this sub and sub1 if certain criteria not met)
else continue
code
end sub
I know I could set a variable to true or false, but was wondering if
there was a way to just exit all subs/macros.
Regards Robert

exit sub
 

What about:

If Condition Then
Exit Sub
End If

exit sub
 

Thanks for both your replys. Thats what I was thinking, thanks for the
confirmation.
Regards Robert