Disable cell warning/error messages
 

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

Disable cell warning/error messages
 

Chad,

Try:

Application.ErrorCheckingOptions.InconsistentFormu la = False

HTH,
Bernie
MS Excel MVP


wrote in message
oups.com...
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

Disable cell warning/error messages
 

Worked like a charm, thanks!