ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error handling in VBA 6.3 in Excel 2002 (https://www.excelbanter.com/excel-programming/370847-error-handling-vba-6-3-excel-2002-a.html)

Bonsai Bill

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!

Dave Peterson

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

Dave Peterson

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com