Ignoring error messages

Posted by Robert Yerby on December 19, 2000 1:02 AM

How do I get Excel macros to ignore error messages either totally or for a portion of the process.

Posted by JAF on December 19, 2000 4:20 AM

It depends on what error messages you're trying to ignore, but the following should help:

Application.DisplayAlerts:= False
'Code you want to ignore error messages on
Application.DisplayAlerts:= True

If that doesn't help, can you post some more details about the type of error messages you're trying to ignore.

JAF