View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?