xlErrorChecks |
| Specifies the type of error object to be retrieved from the Errors collection. |
| 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) |
| 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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top