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