InconsistentFormula Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

When set to True (default), Microsoft Excel identifies cells containing an inconsistent formula in a region. False disables the inconsistent formula check. Read/write Boolean.


expression   Required. An expression that returns one of the objects in the Applies To list.


Consistent formulas in the region must reside to the left and right or above and below the cell containing the inconsistent formula for the InconsistentFormula property to work properly.


In the following example, when the user selects cell B4 (which contains an inconsistent formula), the AutoCorrect Options button appears. 

  Sub CheckFormula()

    Application.ErrorCheckingOptions.InconsistentFormula = True

    Range("A1:A3").Value = 1
    Range("B1:B3").Value = 2
    Range("C1:C3").Value = 3

    Range("A4").Formula = "=SUM(A1:A3)"  ' Consistent formula.
    Range("B4").Formula = "=SUM(B1:B2)"  ' Inconsistent formula.
    Range("C4").Formula = "=SUM(C1:C3)"  ' Consistent formula.

End Sub