ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Newbie Q: What does "On error goto 0" mean? (https://www.excelbanter.com/excel-programming/336604-newbie-q-what-does-error-goto-0-mean.html)

*¡¸ My-Ricky ¡¸*

Newbie Q: What does "On error goto 0" mean?
 
Dear all,

I saw so programs use the code "On error goto 0". What does it mean actually and when should I apply
this code to my vba program?

Thanks in advance




--




Bob Phillips[_6_]

Newbie Q: What does "On error goto 0" mean?
 
As written in VBA help

Disables any enabled error handler in the current procedure.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"*¡¸ My-Ricky ¡¸*" wrote in message
...
Dear all,

I saw so programs use the code "On error goto 0". What does it mean

actually and when should I apply
this code to my vba program?

Thanks in advance




--






Bob Umlas

Newbie Q: What does "On error goto 0" mean?
 
If there had been an error handler, such as On error resume next, or on
error goto MyLabel, then after this statement is executed, "normal" error
handling is reinstated -- that is, as if there were no error handler; that
is, if you get an error, you will see Excel's default/normal/usual error
message.

"*¡¸ My-Ricky ¡¸*" wrote in message
...
Dear all,

I saw so programs use the code "On error goto 0". What does it mean
actually and when should I apply
this code to my vba program?

Thanks in advance




--







All times are GMT +1. The time now is 03:49 AM.

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