View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Stopping a 'multi-level' procedure

I have some longer macros that have the structu
sub toplevel()
call nextlevel 'or call nextlevel1(a,b,c)
'and in the nextlevel code
call lower_level 'or call lower_level2(d,e,f)

In many of the lower_level procedures there is error checking where 'exit
sub' is used to stop execution. It's getting tiresome to code all of the
'back track' conditions in order to stop the execution of the toplevel sub.

Is there an Excel vba way of immediately stopping the top most sub when a
lower level sub contains an error?

Thanks,
--
Neal Z