Add(DataValidationRule,WorksheetReferenceCollection) Method

Applies a data validation rule to the a set of references.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub Add( _
   ByVal rule As DataValidationRule, _
   ByVal references As WorksheetReferenceCollection _
)

public void Add( 
   DataValidationRule rule,
   WorksheetReferenceCollection references
)

Parameters

rule: The data validation rule to apply to the set of references.
references: The reference to which the data validation rule should be applied.

Exceptions

Exception	Description
System.ArgumentNullException	Occurs when rule is null.
System.ArgumentNullException	Occurs when references is null.
System.ArgumentException	Occurs when the references are from a worksheet other than this collection.
System.ArgumentException	Occurs when the rule already applied to another worksheet.
System.ArgumentException	Occurs when the rule is invalid based on its rule type's requirements.
System.ArgumentException	Occurs when the one or more of the cells in the references collection are in the totals row of a table.

Requirements

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DataValidationRuleCollection Class
DataValidationRuleCollection Members
Overload List

View on GitHub

Ignite UI | Help Topics

Add(DataValidationRule,WorksheetReferenceCollection) Method

Parameters

Reference