Error.Ignore Property (Excel)
Allows the user to set or return the state of an error checking option for a range. False enables an error checking option for a range. True disables an error checking option for a range. Read/write Boolean.
Syntax
expression .Ignore
expression A variable that represents an Error object.
Remarks
Reference the ErrorCheckingOptions object to view a list of index values associated with error checking options.
Example
This example disables the ignore flag in cell A1 for checking empty cell references.
Sub IgnoreChecking()
Range("A1").Select
' Determine if empty cell references error checking is on, if not turn it on.
If Application.Range("A1").Errors(xlEmptyCellReferences).Ignore = True Then
Application.Range("A1").Errors(xlEmptyCellReferences).Ignore = False
MsgBox "Empty cell references error checking has been enabled for cell A1."
Else
MsgBox "Empty cell references error checking is already enabled for cell A1."
End If
End Sub