FindRule(WorksheetCell) Method

Find the data validation rule applied to the specified cell.

Syntax

Visual Basic

'Declaration
 
Public Function FindRule( _
   ByVal cell As WorksheetCell _
) As DataValidationRule

C#

public DataValidationRule FindRule( 
   WorksheetCell cell
)

Parameters

cell

The cell to test.

Return Value

A DataValidationRule-derived instance or null if the cell has no 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.

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