exit sub

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

RobcPettit

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
 
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).
 
Thanks for both your replys. Thats what I was thinking, thanks for the
confirmation.
Regards Robert
 
Back
Top