Cell related procedures in class ErrorCheckingOptions (Excel VBA)

This page presents procedures from class ErrorCheckingOptions related to the theme Cell: EmptyCellReferences and OmittedCells

EmptyCellReferences

When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells containing formulas that refer to empty cells. False disables empty cell reference checking.

Application.ErrorCheckingOptions.EmptyCellReferences = True

OmittedCells

When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, the selected cells that contain formulas referring to a range that omits adjacent cells that could be included. False disables error checking for omitted cells.

Application.ErrorCheckingOptions.OmittedCells = True