xlErrorChecks

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

xlEmptyCellReferencesThe cell contains a formula referring to empty cells (7)
xlEvaluateToErrorThe cell evaluates to an error value (1)
xlInconsistentFormulaThe cell contains an inconsistent formula for a region (4)
xlInconsistentListFormula(Added in 2007) The cell contains an inconsistent formula for a list (9)
xlListDataValidationData in the list contains a validation error (8)
xlNumberAsTextNumber entered as text (3)
xlOmittedCellsCells omitted (5)
xlTextDateDate entered as text (2)
xlUnlockedFormulaCellsFormula cells are unlocked (6)

xlEmptyCellReferences
The cell contains a formula referring to empty cells (7)
xlEvaluateToError
The cell evaluates to an error value (1)
xlInconsistentFormula
The cell contains an inconsistent formula for a region (4)
xlInconsistentListFormula
(Added in 2007) The cell contains an inconsistent formula for a list (9)
xlListDataValidation
Data in the list contains a validation error (8)
xlNumberAsText
Number entered as text (3)
xlOmittedCells
Cells omitted (5)
xlTextDate
Date entered as text (2)
xlUnlockedFormulaCells
Formula cells are unlocked (6)

REMARKS
* Added in 2002.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top