Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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




--



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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




--





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 301
Default 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




--





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on "On Error GoTo skip" dan Excel Discussion (Misc queries) 2 July 1st 07 10:48 PM
Subroutine vs GOTO "On Error" Bob Phillips[_6_] Excel Programming 0 July 14th 05 10:12 PM
Subroutine vs GOTO "On Error" Jim Thomlinson[_4_] Excel Programming 0 July 14th 05 09:28 PM
Subroutine vs GOTO "On Error" K Dales[_2_] Excel Programming 0 July 14th 05 09:21 PM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"