Syntax

expression.IgnoreBlank

expression A variable that represents a Validation object.

Remarks

If the IgnoreBlank property is True, cell data is considered valid if the cell is blank, or if a cell referenced by either the MinVal or MaxVal property is blank.

Example

This example causes data validation for cell E5 to allow blank values.

Visual Basic for Applications 
Range("e5").Validation.IgnoreBlank = True
allow empty cells in range data validation ignore Ignore Blank ignore blank cells range validation Ignore Blank Property IgnoreBlank ignoreblank property set data validation permit blanks

See also: