Find(String,Worksheet) Method

Finds a named reference in the collection with a scope of the specified worksheet.

Syntax

Visual Basic

'Declaration
 
Public Overloads Function Find( _
   ByVal name As String, _
   ByVal worksheetScope As Worksheet _
) As NamedReference

C#

public NamedReference Find( 
   string name,
   Worksheet worksheetScope
)

Parameters

name

The name of the named reference to find.

worksheetScope

The worksheet that the named reference found must have a scope of.

Return Value

The named reference with the specified name or null if the named reference was not found.

Exceptions

Exception	Description
System.ArgumentNullException	name is null or empty.
System.ArgumentNullException	worksheetScope is null.

Remarks

Named reference names are compared case-insensitively.

Requirements

Target Platforms: Windows 10, 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