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