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. |