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.