Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 573
Default Where does an "On error resume next" statement apply?

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Where does an "On error resume next" statement apply?

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" wrote in message
ups.com...
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
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" NOT working... Chris M Excel Programming 2 July 13th 05 10:30 PM
how to stop "On error resume next" ? Alex St-Pierre Excel Programming 0 February 11th 05 02:03 PM
Problem with "On error resume next" with "custom VLookup" Factivator Excel Programming 3 July 20th 04 04:42 PM
Need help in excel with "Statement invalid outside Type block. " error Brent[_6_] Excel Programming 3 January 17th 04 03:03 AM
"On Error Resume Next" Question Jim[_26_] Excel Programming 1 September 20th 03 07:38 PM


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

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

About Us

"It's about Microsoft Excel"