View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nile_Hef[_2_] Nile_Hef[_2_] is offline
external usenet poster
 
Posts: 23
Default "On Error" help required

You need an 'Exit Sub' before the start of your 'Thyagaraj_Not_Found: '
error-handling code. Otherwise the code runs all the way to 'End Sub', line
by line, including the lines in your error handler.

Personally, I would insert a label for the 'Exit' code, so that the
error-handler (and any other exit point in your code) can resume at a block
of code containing any 'cleanup' routines you use at the end of the procedu


ExitSub:
[cleanups - erase arrays, set objects = Nothing etc.]
Exit Sub

ErrThyagaraj_Not_Found:
[Error-Handling code]
Resume ExitSub

End Sub