Share via


Errors.Item Property (Excel)

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

Concepts

Errors Object Members

Errors Object