Excel 2003 On Error Resume Next doesn't work for me
Avoid the error.
--
Regards,
Tom Ogilvy
"Leadee" wrote in message
...
Thank you for the info. So what is the solution to work with non-trapple
errors?
"Tom Ogilvy" wrote:
On Error Resume Next only works with Trappable errors. I suspect, that
if
it isn't working, then you are getting an error that is not trappable.
--
Regards,
Tom Ogilvy
"Leadee" wrote in message
...
I just migrated all of my apps from Excel 2000 to Excel 2003. Now the
VBA
code fails whereever I had an On Error Resume Next statement. It's as
if
that
statement is being ignored. My current error is a MAPI_E_NOT_FOUND
error,
which is triggering a run time error even though I have an on error
resume
next line above it. Any ideas as to how to trap this error in Excel
2003?
|