Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just trying to write a little error handler. On the first occurence of the
error it goes to err_handler nicely, but then I want it to crash n the second occurence and go to Debug in the usual way, so that the problem line is highlighted and i can maybe correct it, and continue. What I don't know is how to set it to crash after the "ELSE". Windows(xx).Activate GoTo end_open_proc err_handler: If Not err_flag = "Y" Then Application.EnableEvents = True Application.Run "PERSONAL.xls!WAV_CRASH" MsgBox "Error " & Err.Number & " " & Err.Description err_flag = "Y" Resume Else 'what goes here to make it crash on the second occurence of the error? End If end_open_proc: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Set Error handling INSIDE error-trap | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error handling with a handling routine | Excel Programming | |||
Error Handling | Excel Programming |