Share via

ErrorCheckingOptions.InconsistentFormula Property

  • Article
Excel Developer Reference

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.

Syntax

expression.InconsistentFormula

expression   A variable that represents an ErrorCheckingOptions object.

Remarks

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.

Example

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

Visual Basic for Applications 
  Sub CheckFormula()

Application.ErrorCheckingOptions.<strong>InconsistentFormula</strong> = 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

See Also