Apparently the Excel IDE over-rides the 'On Error' capability.
Is there an Excel environment where it doesn't?
i.e. can you compile a macro and run it faster?

In any case, I'm doing some runtime stuff that seems to need error
trapping.

e.g. reading the name of a Range where it doesn't have one.
and creating Ranges from user info that might be invalid.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Not sure what you mean by "over-rides", can you give a code example?

Tim


"peter" wrote in message
...
Apparently the Excel IDE over-rides the 'On Error' capability.
Is there an Excel environment where it doesn't?
i.e. can you compile a macro and run it faster?

In any case, I'm doing some runtime stuff that seems to need error
trapping.

e.g. reading the name of a Range where it doesn't have one.
and creating Ranges from user info that might be invalid.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Tim,

Thanks for replying.

I tried 2 kinds of 'On Error'
e.g.
Application.Volatile
and
On Error Resume Next
or
On Error Goto aMsgBox
but they were ignored,
i.e. the IDE gave me the normal choice
of Ending or Debugging.

I put the 'On Error' immediately before
the buggy statement.

I tried i = i/0 for example, as a new Sub.

Peter

Using 'On Error'
From: Tim Williams

Not sure what you mean by "over-rides", can you give a code example?

Tim



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

As far as I know Application.Volatile doesn't have antything to do
with error handling.

Is "aMsgBox" a line label?

Make sure you haven't checked "break on all errors" in the VBE under
ToolsOptionsGeneral Error Trapping

Tim.


"peter" wrote in message
...

Hi Tim,

Thanks for replying.

I tried 2 kinds of 'On Error'
e.g.
Application.Volatile
and
On Error Resume Next
or
On Error Goto aMsgBox
but they were ignored,
i.e. the IDE gave me the normal choice
of Ending or Debugging.

I put the 'On Error' immediately before
the buggy statement.

I tried i = i/0 for example, as a new Sub.

Peter

Using 'On Error'
From: Tim Williams

Not sure what you mean by "over-rides", can you give a code example?

Tim



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Make sure you haven't checked "break on all errors" in the VBE under
ToolsOptionsGeneral Error Trapping

YES!

This looks exactly what I need to change.

Thanks a lot.

Peter.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!