View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Error handler resume

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!