VBA, On Error doesn't catch second error in code

On Error doesn't catch second error in code

Author	Message
Rick #1 / 4	On Error doesn't catch second error in code I have set up a On Error GoTo statement and the error handling code (at end of code). The On Error GoTo statement is between the Dim statements and normal code. It works fine if the error occurs only once during the running of the macro. However, the second time the error occurs, the macro fails and the error is not handled by the error handling code. Does the On Error GoTo statement have to be within the code loop to reset? Is there a reset command? Thanks
Mon, 18 Oct 2004 21:30:02 GMT

The Luggag #2 / 4	On Error doesn't catch second error in code I think you need to do an Err.Clear after you've handled the error, then the normal On Error code should kick in again. Quote: > I have set up a On Error GoTo statement and the error > handling code (at end of code). The On Error GoTo > statement is between the Dim statements and normal code. > It works fine if the error occurs only once during the > running of the macro. However, the second time the error > occurs, the macro fails and the error is not handled by > the error handling code. Does the On Error GoTo statement > have to be within the code loop to reset? Is there a reset > command? Thanks
Mon, 18 Oct 2004 22:58:06 GMT

Rick #3 / 4	On Error doesn't catch second error in code Thanks Quote: >-----Original Message----- >Have you tried Err.Clear in your error handling routine. >Mark Baird >>-----Original Message----- >>I have set up a On Error GoTo statement and the error >>handling code (at end of code). The On Error GoTo >>statement is between the Dim statements and normal code. >>It works fine if the error occurs only once during the >>running of the macro. However, the second time the error >>occurs, the macro fails and the error is not handled by >>the error handling code. Does the On Error GoTo statement >>have to be within the code loop to reset? Is there a >reset >>command? Thanks >>. >.
Tue, 19 Oct 2004 04:59:01 GMT

Page 1 of 1

[ 4 post ]