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

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment