Version

Remove(WorksheetCell) Method

Removes the data validation rule form the cell if one is applied.
Syntax
'Declaration
 
Public Overloads Function Remove( _
   ByVal cell As WorksheetCell _
) As Boolean
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
ExceptionDescription
System.ArgumentNullExceptionOccurs when cell is null.
System.ArgumentExceptionOccurs 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

See Also