XlErrorChecks Enumeration
Specifies the type of error object to be retrieved from the Errors collection.
Version Information
Version Added: Excel
| Name | Value | Description |
|---|---|---|
| xlEmptyCellReferences | 7 | The cell contains a formula referring to empty cells. |
| xlEvaluateToError | 1 | The cell evaluates to an error value. |
| xlInconsistentFormula | 4 | The cell contains an inconsistent formula for a region. |
| xlInconsistentListFormula | 9 | The cell contains an inconsistent formula for a list. |
| xlListDataValidation | 8 | Data in the list contains a validation error. |
| xlNumberAsText | 3 | Number entered as text. |
| xlOmittedCells | 5 | Cells omitted. |
| xlTextDate | 2 | Date entered as text. |
| xlUnlockedFormulaCells | 6 | Formula cells are unlocked. |