PC Review


Reply
Thread Tools Rate Thread

Where does an "On error resume next" statement apply?

 
 
davegb
Guest
Posts: n/a
 
      6th Dec 2006
If I put an "On error resume next" command in a macro, and it's in a
sub called from another sub, does it end when the sub it was in ends,
or does it still apply back in the parent sub?

TIA

 
Reply With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      6th Dec 2006
See http://www.cpearson.com/excel/ErrorHandling.htm for an in depth
discussion of error handling.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"davegb" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If I put an "On error resume next" command in a macro, and it's in a
> sub called from another sub, does it end when the sub it was in ends,
> or does it still apply back in the parent sub?
>
> TIA
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing "opens with" settings does not apply to "open" or "print"commands Anne Rensonnet Windows XP General 1 7th Jul 2008 12:51 PM
Syntax error in UPDATE statement - field name "Upper", or "Lower" =?Utf-8?B?SWdvciBHZWd1c2lu?= Microsoft ADO .NET 2 19th Oct 2004 04:17 PM
Loud "beeping" noises on startup and "resume" with Dell Inspiron 1150 Windows XP Performance 3 1st Oct 2004 05:52 PM
Problem with "On error resume next" with "custom VLookup" =?Utf-8?B?RmFjdGl2YXRvcg==?= Microsoft Excel Programming 4 21st Jul 2004 02:21 AM
No "On resume, display welcome screen"...yes "Fast User Switching" is enabled Kimone Windows XP Security 1 28th Dec 2003 07:47 PM


Features
 

Advertising
 

Newsgroups
 


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