Errors.Item Property

Excel Developer Reference

Returns a single member of the Error object.

Syntax

expression.Item(Index)

expression   A variable that represents an Errors object.

Parameters

Name Required/Optional Data Type Description
Index Required Variant The index of the member.

Remarks

Index can also be one the following constants.

xlEvaluateToError The cell evaluates to an error value.
xlTextDate The cell contains a text date with 2 digit years.
xlNumberAsText The cell contains a number stored as text.
xlInconsistentFormula The cell contains an inconsistent formula for a region.
xlOmittedCells The cell contains a formula omitting a cell for a region.
xlUnlockedFormulaCells The cell which is unlocked contains a formula.
xlEmptyCellReferences The cell contains a formula referring to empty cells.

See Also