Error Object - Microsoft Office Excel

Remarks

Use the Item property of the Errors object to return an Error object.

Once an Error object is returned, you can use the Value property, in conjunction with the Errors property to check whether a particular error checking option is enabled.

Note
Be careful not to confuse the Error object with error handling features of Visual Basic.

Example

The following example creates a formula in cell A1 referencing empty cells, and then it uses Item(), where identifies the error type, to display a message stating the situation.

Visual Basic for Applications

Visual Basic for Applications
Sub CheckEmptyCells() Dim rngFormula As Range Set rngFormula = Application.Range("A1") ' Place a formula referencing empty cells. Range("A1").Formula = "=A2+A3" Application.ErrorCheckingOptions.EmptyCellReferences = True ' Perform check to see if EmptyCellReferences check is on. If rngFormula.Errors.Item(xlEmptyCellReferences).Value = True Then MsgBox "The empty cell references error checking feature is enabled." Else MsgBox "The empty cell references error checking feature is not on." End If End Sub

Sub CheckEmptyCells() Dim rngFormula As Range Set rngFormula = Application.Range("A1") ' Place a formula referencing empty cells. Range("A1").Formula = "=A2+A3" Application.ErrorCheckingOptions.EmptyCellReferences = True ' Perform check to see if EmptyCellReferences check is on. If rngFormula.Errors.Item(xlEmptyCellReferences).Value = True Then MsgBox "The empty cell references error checking feature is enabled." Else MsgBox "The empty cell references error checking feature is not on." End If End Sub

See also: