I'm having a strange problem with by VBA environment; Excel XP. Whenever I'm
running some code and an error occurs, the procedure just drops out. No
error message is raised so it's making debugging very difficult! The error
option is set to 'Break on Unhandled Errors' as per usual, but no breaks
actually occur?

If I create a sub with a divide by zero error in the same module, then the
run-time error does occur, so I'm really confused. Why would run-time errors
behave one way in one sub, but a different way in another. And yes, no error
handler has been engaged (ie neither sub has an On Error Goto statement).

Any ideas?

Thanks


Damien

I vaguely recall running into something similar a long time ago and no
satisfactory explanation as to why. You might want to search the
google.com archives of the xl newsgroups. Alternatively, step through
the code with F8 (or SHIFT+F8 when appropriate) and see where XL/VBA
just quits.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I'm having a strange problem with by VBA environment; Excel XP. Whenever I'm
running some code and an error occurs, the procedure just drops out. No
error message is raised so it's making debugging very difficult! The error
option is set to 'Break on Unhandled Errors' as per usual, but no breaks
actually occur?

If I create a sub with a divide by zero error in the same module, then the
run-time error does occur, so I'm really confused. Why would run-time errors
behave one way in one sub, but a different way in another. And yes, no error
handler has been engaged (ie neither sub has an On Error Goto statement).

Any ideas?

Thanks


Damien

Damien

I seem to remember that happening to me, but don't remember the details.
What kind of error do you expect but aren't getting? Are the errors in a
class module like a userform, Sheet1, ThisWorkbook or a custom class module?

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Damien wrote:
I'm having a strange problem with by VBA environment; Excel XP.
Whenever I'm running some code and an error occurs, the procedure
just drops out. No error message is raised so it's making debugging
very difficult! The error option is set to 'Break on Unhandled
Errors' as per usual, but no breaks actually occur?

If I create a sub with a divide by zero error in the same module,
then the run-time error does occur, so I'm really confused. Why
would run-time errors behave one way in one sub, but a different way
in another. And yes, no error handler has been engaged (ie neither
sub has an On Error Goto statement).

Any ideas?

Thanks


Damien

I believe I have this occasionally. No error message, but the name of the
procedure is sometimes highlighted in yellow (rather than a line of code).
As I recall (and I could be mistaken) it is usually an event procedure.
Also, it seems the error is immediate on running.

In such cases, having just made changes, the cause is usually found after
careful inspection. I rarely step through my code, so I can't say if that
would be a better suggestion or not.

--
Regards,
Tom Ogilvy





"Dick Kusleika" wrote in message
...
Damien

I seem to remember that happening to me, but don't remember the details.
What kind of error do you expect but aren't getting? Are the errors in a
class module like a userform, Sheet1, ThisWorkbook or a custom class
module?

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Damien wrote:
I'm having a strange problem with by VBA environment; Excel XP.
Whenever I'm running some code and an error occurs, the procedure
just drops out. No error message is raised so it's making debugging
very difficult! The error option is set to 'Break on Unhandled
Errors' as per usual, but no breaks actually occur?

If I create a sub with a divide by zero error in the same module,
then the run-time error does occur, so I'm really confused. Why
would run-time errors behave one way in one sub, but a different way
in another. And yes, no error handler has been engaged (ie neither
sub has an On Error Goto statement).

Any ideas?

Thanks


Damien

Tom Ogilvy wrote:
I believe I have this occasionally. No error message, but the name
of the procedure is sometimes highlighted in yellow (rather than a
line of code). As I recall (and I could be mistaken) it is usually an
event procedure.

If that's the case here, I wonder if checking "Break in Class Modules" would
expose the error better. Maybe where the error is is just being masked.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com