View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Exit a Procedure from a Sub within a sub

Usually using End is bad practice as it resets all your VBA code and
variables without going through any exit routines.


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Steve" wrote in message
...
How about "End"

" wrote:

I'm running a procedure that calls other macros. In one of these macros
I
have an if then statement that if true I want to exit the entire
procedure.
What is the code for this? Exit Sub just exits the current sub I'm
running,
not the entire larger one.

Thanks

Adam Bush