Error message handling and resuming...

[RobbieC]

Hi there, I have a macro which I need to try and debug...

I can identify the various errors, but is it possible to resume the macro if certain errors are picked up? I can then weed out which errors are the issues and tend to them applicably. This is the code I have so far:

On Error GoTo ErrorMessage

'my long macro goes here

ProcedureDone:
Exit Sub
 
ErrorMessage:


Select Case Err.number
Case 1004
[COLOR=#ff0000]    'ignore error and resume macro[/COLOR]
Case Else
' All outstanding errors
MsgBox Err.number & ": " & Error.Description
End Select


Resume ProcedureDone

If you can help me out, I 'd be very happy

Thanks

 

[FormR]

Hi, did you try just using:

Resume Next

I think you also have a typo here, and that "Error" should just be "Err":

MsgBox Err.Number & ": " & Error.Description

 

[RobbieC]

Thank you FormR.... I didn't try that and it worked first time - gonna save alot of hassle in the future!

and I changed the Error to Err

Thanks very much for your help