Using 'On Error'

[peter]

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!

 

[Tim Williams]

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

Tim

 

[peter]

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

Re: 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!

 

[Tim Williams]

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
Tools>>Options>>General >> Error Trapping

Tim.

 

[peter]

Make sure you haven't checked "break on all errors" in the VBE under
Tools>>Options>>General >> 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!