Remove(WorksheetCell) Method

Removes the data validation rule form the cell if one is applied.

Syntax

Visual Basic

'Declaration
 
Public Overloads Function Remove( _
   ByVal cell As WorksheetCell _
) As Boolean

C#

public bool Remove( 
   WorksheetCell cell
)

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	Description
System.ArgumentNullException	Occurs when cell is null.
System.ArgumentException	Occurs when the cell is from a worksheet other than this collection.

Remarks

If the rule is only applied to the specified cell, it will be removed from the collection.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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