Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Error handling in VBA 6.3 in Excel 2002

I cannot get the On Error Resume Next function to work. I deleted Options
Explicit but there must be something else I need to do. DisplayAlerts is set
to false. I am running XP. Any help or suggested links would be greatly
appreciated.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Error handling in VBA 6.3 in Excel 2002

Maybe...

Within the VBE.
tools|options|General Tab|Error Trapping Section
Maybe you have "break on all errors" checked.

I use "break on unhandled errors"

Bonsai Bill wrote:

I cannot get the On Error Resume Next function to work. I deleted Options
Explicit but there must be something else I need to do. DisplayAlerts is set
to false. I am running XP. Any help or suggested links would be greatly
appreciated.

Thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Error handling in VBA 6.3 in Excel 2002

And put that "Option Explicit" back!

Bonsai Bill wrote:

I cannot get the On Error Resume Next function to work. I deleted Options
Explicit but there must be something else I need to do. DisplayAlerts is set
to false. I am running XP. Any help or suggested links would be greatly
appreciated.

Thanks!


--

Dave Peterson
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
handling calculated excel cell error messages RK Excel Discussion (Misc queries) 2 October 22nd 07 01:05 PM
Error Handling - On Error GoTo doesn't trap error successfully David Excel Programming 9 February 16th 06 05:59 PM
Error handling with a handling routine ben Excel Programming 0 March 15th 05 03:01 PM
Excel VBA - Error handling problem brutalmetal[_2_] Excel Programming 2 January 21st 04 03:17 AM
Excel Error Handling brutalmetal Excel Programming 1 January 13th 04 02:11 PM


All times are GMT +1. The time now is 12:21 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"