When does ON ERROR reset?

[mark hansen]

I found a problem in a spreadsheet where a userform was looking for the last row. It found and incorrect list if the sheet is filtered. More searching found I need to use ShowAllData before I look for the last row. That caused an error if there were no filters set. So more searching I found I could use On error resume Next which works.

My question is when the On Error reset and go back to stopping and display the error, so I can look at it?

I have the first ShowAllData when I open the work book and another one as I open the userform that asks for data that is then added to the sheet.

Is the On Error Resume Next going to stay in effect the whole time I have the work book open?

Thanks,
Mark

 

[V_Malkoti]

Scope of On Error Resume Next is within the procedure. On Error Resume Next becomes inactive when execution of procedure.

To reset it, you an write
On Error GoTo 0

which deactivates effect of On Error Resume Next.

EDIT: Adding link for reference
https://msdn.microsoft.com/en-us/library/aa266173(v=vs.60).aspx

 

[mark hansen]

Thanks for the quick reply. That's a very good reference I'll use while I tighten up my project. I currently have the code in a module and use a Call ResetFilter to make sure the filters are gone as I set up the user form. If I understood you correctly, the rest of the user form will show errors (which is what I want as I build it) until I can finish it.

Thanks for your help.

Mark