Disable cell warning/error messages

[chad.whyte]

Hello,

I have several hidden cells side-by-side that contain custom
calculations, and am receiving the error: "The formula in this cell
differs from the formulas in this area of the spreadsheet." Since
these cells are hidden, I don't want the user to see the small green
icon in the upper left corner of each cell, and the corresponding error
message.

How do I disable these errors through VBA so they are not visible?

Thank you,

Chad

 

[Bernie Deitrick]

Chad,

Try:

Application.ErrorCheckingOptions.InconsistentFormula = False

HTH,
Bernie
MS Excel MVP

 

[chad.whyte]

Worked like a charm, thanks!