XlErrorChecks Enumeration
Specifies the type of error object to be retrieved from the Errors collection.
Version Information
Version Added: Excel 2007
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. |