ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Resetting error reporting after On Error GoTo (https://www.excelbanter.com/excel-programming/432417-resetting-error-reporting-after-error-goto.html)

Steve

Resetting error reporting after On Error GoTo
 
I have an "On Error GoTo" statement at the beginning of a macro to test for a
particular thing. Once that is done, is there a way of resetting error
reporting as if the "On Error GoTo" was never there?

Jacob Skaria

Resetting error reporting after On Error GoTo
 
Hi Steve

On Error GoTo 0

disables any enabled error handler in the current procedure.

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

I have an "On Error GoTo" statement at the beginning of a macro to test for a
particular thing. Once that is done, is there a way of resetting error
reporting as if the "On Error GoTo" was never there?



All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com