XlErrorChecks enumeration (Excel)
Specifies the type of error object to be retrieved from the Errors collection.
| 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. |
| xlStaleValue | 12 | The cell contains an uncalculated formula. |
| xlTextDate | 2 | Date entered as text. |
| xlUnlockedFormulaCells | 6 | Formula cells are unlocked. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.