Skip to main content

XlErrorChecks enumeration

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

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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>