"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
|