Share via

XlErrorChecks Enumeration

  • Article

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.