Excel.Validation.IgnoreBlank.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Validation.IgnoreBlank property (Excel)	vbaxl10.chm532075	vbaxl10.chm532075	Excel.Validation.IgnoreBlank	91913061-9cc7-8e96-11c3-67d7b84e2e25	05/18/2019	medium

Validation.IgnoreBlank property (Excel)

True if blank values are permitted by the range data validation. Read/write Boolean.

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.

Range("e5").Validation.IgnoreBlank = True

[!includeSupport and feedback]