ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA/XP/2000 On Error Resume Next problem. (https://www.excelbanter.com/excel-programming/332582-re-vba-xp-2000-error-resume-next-problem.html)

Frank McLellan

VBA/XP/2000 On Error Resume Next problem.
 
On 19/6/05 09:10, in article , "Dave
Peterson" wrote:

Jim wants you to turn that to something else.

Under Tools|options|General tab
I have "break on unhandled errors" checked.

Since you had "break on all errors" checked and the code found an error, it
broke (breaked?).




Frank McLellan wrote:

Yes Jim, the Break on all Errors" is checked.

*** Sent via Developersdex
http://www.developersdex.com ***
Thanks Dave. That was it. I had Excel VBE set to "unhandled" in the office
but "all" at home.
Thanks again Dave.


Dave Peterson[_5_]

VBA/XP/2000 On Error Resume Next problem.
 
I'll accept the thanks for Jim. He's on location filming his next movie. (Oh,
wait. This isn't the Oscars!)

Frank McLellan wrote:

On 19/6/05 09:10, in article , "Dave
Peterson" wrote:

Jim wants you to turn that to something else.

Under Tools|options|General tab
I have "break on unhandled errors" checked.

Since you had "break on all errors" checked and the code found an error, it
broke (breaked?).




Frank McLellan wrote:

Yes Jim, the Break on all Errors" is checked.

*** Sent via Developersdex
http://www.developersdex.com ***
Thanks Dave. That was it. I had Excel VBE set to "unhandled" in the office
but "all" at home.
Thanks again Dave.


--

Dave Peterson


All times are GMT +1. The time now is 11:47 AM.

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