Error Properties

Name

Returns

Description

Ignore

Boolean

Get/Set whether error checking is enabled for a range

Value

Boolean

Read-only. Returns whether all the validation criteria are met

Errors Collection Example

Sub CheckForEmptyCellReference() ' Place a formula in cell A1.

Range("A1").Formula = "=B1+C1" 'If Cell B1 is empty

If Range("A1").Errors.Item(xlEmptyCellReferences).Value = True Then

MsgBox "One or more of the referenced cells are empty." End If End Sub

0 0

Post a comment