• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1119
  • Last Modified:

Ignore Errors through VBA


I have some VBA code that populates a spreadsheet, and it works well.  However, a couple of the cells have the Excel error message on them when it's finished.  (The little green triangle in the top left corner that you have to click "Ignore Error" on)  It doesn't matter which error it is, the data isn't going to be changed.

Is there a way to force Excel to ignore these incorrectly labeled errors through VBA so that the user doesn't have to go through and click "Ignore Error" on each cell?  If the answer is no, then that's fine.

1 Solution
Chris BottomleyCommented:
Hello Torrwin,

Try the following but note it occurs at the application level


    With Application.ErrorCheckingOptions
        .BackgroundChecking = True
        .EvaluateToError = False
        .InconsistentFormula = False
    End With

Open in new window

TorrwinAuthor Commented:
Perfect!  Exactly what I was looking for!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now