View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Error handler resume

Arne,
Surely you don't the If as you have the select case
Handler:
Select Case Err.Number
Case 600
'do something......
Case 666
Msgbox "666 error"
Resume Next
Case Else
msgbox "Give Up"
End select

NickHK

"Arne Hegefors" ...
I have a sub in which I call an error handler if certain requirements are
met. I call the error handler and give a message to the user but I want to
continue where the error was. Now it contnues in the main sub for some
reason.

Code for error handler:

Handler:
Select Case Err.Number
Case 600
.......
If Err.Number = 666 Then
Resume Next
End If
end select

and in the sub I call the error handler for that particukar error using:

Err.Raise 666

Please help me out here! Many thanks in advance!