| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Range.Validation property (Excel) |
vbaxl10.chm144215 |
|
|
d1cad7e6-bbfa-e280-33e7-048733efc0bc |
05/11/2019 |
medium |
Returns the Validation object that represents data validation for the specified range. Read-only.
expression.Validation
expression A variable that represents a Range object.
This example causes data validation for cell E5 to allow blank values.
Range("e5").Validation.IgnoreBlank = True[!includeSupport and feedback]