This documentation is archived and is not being maintained.

XlErrorChecks Enumeration

Office 2007
Specifies the type of error object to be retrieved from the Errors collection.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlEmptyCellReferences7The cell contains a formula referring to empty cells.
xlEvaluateToError1The cell evaluates to an error value.
xlInconsistentFormula4The cell contains an inconsistent formula for a region.
xlInconsistentListFormula9The cell contains an inconsistent formula for a list.
xlListDataValidation8Data in the list contains a validation error.
xlNumberAsText3Number entered as text.
xlOmittedCells5Cells omitted.
xlTextDate2Date entered as text.
xlUnlockedFormulaCells6Formula cells are unlocked.


Show: