Expand Minimize
This topic has not yet been rated - Rate this topic

XlErrorChecks Enumeration (Excel)

Published: July 16, 2012

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.