On Error GoTo 0 help

[starlev]

Hi,
I was using On Error GoTo 0
Which was part of another module I found online and modified.
I tried to read on the various forms regarding On Error GoTo 0
However I’m not sure if I use On Error GoTo 0 that means that next time there is an error it will acknowledge the error and notify the user that there is an error.
Can somebody help with this?

Eli

[AB33]

It erases the previous error trapping error, so you are back to normal with out error trapping.
E.g you have a line
on error resume next

if you include on error go to 0, this line will delete(Erase) the resume next.
The purpose of this line is you do not want to apply the error trapping to the entire code.

[starlev]

Thank you for your response.


If I understand you correctly.
That if I use on error resume next if I did not use On Error GoTo 0 the next error I will have it will ignore the error.

Am I correct?

If I understand you correctly.
That if I use on error resume next if I did not use On Error GoTo 0 the next error I will have it will ignore the error.

Am I correct?

[AB33]

Yes, the error trap will pick up any error on the code unless you tell VBA to stop the trapping at a specific line. It is bad practice to put in resume next error trap on all part of the code.
Let' say, I do not want to get an error message on this line. If I do not take out the error trapping after the first line and if there are lines of code after first line and have errors, the code will ignore these errors, hence for using on selective line. You could use it on multiple lines on a single code.

Please Login or Register  to view this content.

[starlev]

Thank you for your explanation is great.