Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 203
Default on error don't resume next?

Hi.
I have a procedure that uses "On Error Resume Next" at the beginning of the
procedure. However, I don't want the procedure to pass by errors after a
certain point. Is there a way to tell vba to "on error dont resume next"? In
other words, is there a way to cancel the "on error resume next" within a
procedure?
Thanks,
Albert C.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default on error don't resume next?

Albert,
On Error GoTo 0

Check the help for "On Error Statement".

NickHK

"Albert" wrote in message
...
Hi.
I have a procedure that uses "On Error Resume Next" at the beginning of

the
procedure. However, I don't want the procedure to pass by errors after a
certain point. Is there a way to tell vba to "on error dont resume next"?

In
other words, is there a way to cancel the "on error resume next" within a
procedure?
Thanks,
Albert C.



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
On Error Resume Next Dan Excel Programming 5 August 19th 06 10:07 PM
On Error {...} Resume Next Edd[_2_] Excel Programming 2 March 15th 06 11:09 PM
On Error Resume Next Nigel Excel Programming 3 August 10th 05 03:34 PM
On Error Resume Next rcalvanese Excel Programming 3 April 11th 05 11:21 PM
On Error Resume Next Mike[_58_] Excel Programming 3 November 23rd 03 05:09 PM


All times are GMT +1. The time now is 11:12 PM.

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"