Error CheckingOptions Collection Properties

Name

Returns

Description

Background Checking

Boolean

Set/Get whether background error checking is set; that is, whether the autocorrect button will appear in cells that contain errors

EmptyCell References

Boolean

Set/Get whether error checking is on for cells containing formulas that refer to empty cells

EvaluateToError

Boolean

Set/Get whether error checking is on for cells that evaluate to an error value

Inconsistent Formula

Boolean

Set/Get whether error checking is on for cells containing an inconsistent formula in a region

Inconsistent TableFormula

Boolean

Set/Get whether error checking is on for cells containing an inconsistent formula in a Table

IndicatorColor Index

XlColor Index

Set/Get the color of the indicator for error checking options

ListData Validation

Boolean

The property will return True if data validation is enabled for a list

NumberAsText

Boolean

Set/Get whether error checking is on for numbers written as text

Name

Returns

Description

OmittedCells

Boolean

Set/Get whether error checking is on for cells that contain formulas referring to a range that omits adjacent cells that could be included

TextDate

Boolean

Set/Get whether error checking is on for cells that contain a text date with a two-digit year

UnlockedForm ulaCells

Boolean

Set/Get whether error checking is on for cells that are unlocked and contain a formula

0 0

Post a comment