Page History

{description}
{excerpt}Assigns a data validation rule to all cells in the Range. If the [DataValidation] object uses a local reference or area in a formula (i.e. "=A5:B7"), then the range will adjust those local references accordingly based on the range's location. The original {{DataValidation}} object will not be affected.
{excerpt}
{signature:C#}
 public void SetDataValidation(DataValidation dataValidation)
{signature}{signature:vb.net}
Public Sub SetDataValidation(ByVal dataValidation As DataValidation)
{signature}
{parameters}
{param:dataValidation}A [DataValidation|DataValidation] object representing the data validation rule to assign to the Range.{param}
{example}{code:csharp|title=C#}
rng.SetDataValidation(myDataValidation);{code}
{code:vb.net|title=vb.net}
rng.SetDataValidation(myDataValidation){code}

{example}