View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
tercerojista tercerojista is offline
external usenet poster
 
Posts: 5
Default Why isn't my error handling working?!

On May 2, 11:20 am, "Peter T" <peter_t@discussions wrote:
I'm still in the dark as to why the error handler wasn't handling the
error that was arising, though...


If(?) you are referring to the error handlers in the code in your first
post, there is no Resume statement in this one -

On Error GoTo NextRow
' code
NextRow:

I did suggest an approach you could have adapted into your routine purely
for the error handling issue, perhaps you didn't see it. (Nick's alternative
approach for your routine as a whole was of course a better solution.)

Regards,
Peter T


Thanks for the suggestion. The lack of a Resume statement does indeed
seem to be what's making things fail here, and in my other code. Now
I know not to put "GoTo Linelabel" at the end of the error handling
procedure, but "Resume Linelabel" :-D