UseBlank Element (Microsoft Excel)

Specifies whether blank cells in a range are used when validating input data.

Contained In

DataValidation

Remarks

If <x:UseBlank/> is specified, blank cells are used to validate the input data. If the element is not specified, any blank cells in the specified validation range are skipped during data validation.

Example

See the example in the DataValidation element topic.