ErrorCheckingOptions.EmptyCellReferences Property

Syntax

expression.EmptyCellReferences

expression A variable that represents an ErrorCheckingOptions object.

Example

In the following example, the AutoCorrect Options button appears for cell A1 which contains a formula that references empty cells.

Visual Basic for Applications
`Sub CheckEmptyCells() Application.ErrorCheckingOptions.EmptyCellReferences = True Range("A1").Formula = "=A2+A3" End Sub`

Empty empty cell references emptycell emptycellreferences emptycellreferences property

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. Read/write Boolean.