Formula related procedures in class ErrorCheckingOptions (Excel VBA)

This page presents procedures from class ErrorCheckingOptions related to the theme Formula: InconsistentFormula, InconsistentTableFormula and UnlockedFormulaCells


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

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.

Application.ErrorCheckingOptions.InconsistentFormula = True


Returns True if the table formula is inconsistent.

Application.ErrorCheckingOptions.InconsistentTableFormula = True


When set to True (default), Microsoft Excel identifies selected cells that are unlocked and contain a formula. False disables error checking for unlocked cells that contain formulas.

Application.ErrorCheckingOptions.UnlockedFormulaCells = True