IgnoreBlank Property
Applies To
Validation object.
Description
True if blank values are permitted by the range data validation. Read/write Boolean.
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.
See Also
Add method (Validation object), ErrorMessage property, ErrorTitle property, InCellDropdown property, InputMessage property, InputTitle property.
Example
This example causes data validation for cell E5 to allow blank values.
Range("E5").Validation.IgnoreBlank = True