Find the data validation rule applied to the specified cell. Overload List
Gets a collection of all the references which have the specified or an equivalent rule applied to them. Syntax Parameters rule The rule to test. Return Value A collection of references in the Worksheet with a rule applied to it that is equivalent to the specified rule.
Gets or sets the references which have the data validation rule applied to it. Syntax Parameters rule A data validation rule. Exceptions Exception Description System.ArgumentNullException Occurs when the rule is null. System.Collections.Generic.KeyNotFoundException Occurs when the property is retrieved and the rul...
Removes the specified rule from the Worksheet. Syntax Parameters rule The rule which should be removed. Return Value True if the rule was contained on the Worksheet before removal; False otherwise. Exceptions Exception Description System.ArgumentNullException Occurs when rule is null.
Removes the data validation rule form the cell if one is applied. Syntax Parameters cell The cell which should have its data validation rule cleared. Return Value True if the data validation rule was found and removed from the cell; False if the cell had no data validation rule applied. Exceptions Exception Descri...
Removes the data validation rule form all cells in the specified collection. Syntax Parameters references The collection of references which should have its data validation rules cleared. Return Value True if the data validation rule was found and removed from any cells in the collection; False if the cells had no...
Removes the data validation rule form all cells in the specified region. Syntax Parameters region The region which should have its data validation rules cleared. Return Value True if the data validation rule was found and removed from any cells in the region; False if the region had no data validation rule applied...
Removes the specified rule from the Worksheet. Overload List
Gets the references which have the specified rule applied to them or null if the rule is not used on the Worksheet. Syntax Parameters rule The rule to test.references [Out] When this method returns, contains the references which have the rule applied to them or null if the rule isnt applied on the Worksheet. Retur...
Public Properties Public Methods