Version

Remove(WorksheetRegion) Method

Removes the data validation rule form all cells in the specified region.
Syntax
'Declaration
 
Public Overloads Function Remove( _
   ByVal region As WorksheetRegion _
) As System.Boolean
public System.bool Remove( 
   WorksheetRegion region
)

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.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionOccurs when region is null.
System.ArgumentExceptionOccurs when the region is from a worksheet other than this collection.
Remarks

If any rules in the collection are not applied to any cells after this operation, they will be removed from the collection.

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

See Also

View on GitHub