SpreadsheetGear 2023
Find Method (IRange)


SpreadsheetGear Namespace > IRange Interface : Find Method
Specifies the text to find.
Specifies the single cell to start after within this range, or null to start after the top-left cell of this range.
Specifies whether to search formulas or values.
Specifies partial or complete match.
Specifies whether to search by rows or by columns.
Specifies whether to search forward (next) or backwards (previous).
Specifies whether text searches should match case.
Searches for the specified text according to the specified options, and returns an IRange representing the found cell or null if no cell is found.
Syntax
'Declaration
 
Function Find( _
   ByVal what As System.String, _
   ByVal after As IRange, _
   ByVal lookIn As FindLookIn, _
   ByVal lookAt As LookAt, _
   ByVal searchOrder As SearchOrder, _
   ByVal searchDirection As SearchDirection, _
   ByVal matchCase As System.Boolean _
) As IRange
'Usage
 
Dim instance As IRange
Dim what As System.String
Dim after As IRange
Dim lookIn As FindLookIn
Dim lookAt As LookAt
Dim searchOrder As SearchOrder
Dim searchDirection As SearchDirection
Dim matchCase As System.Boolean
Dim value As IRange
 
value = instance.Find(what, after, lookIn, lookAt, searchOrder, searchDirection, matchCase)

Parameters

what
Specifies the text to find.
after
Specifies the single cell to start after within this range, or null to start after the top-left cell of this range.
lookIn
Specifies whether to search formulas or values.
lookAt
Specifies partial or complete match.
searchOrder
Specifies whether to search by rows or by columns.
searchDirection
Specifies whether to search forward (next) or backwards (previous).
matchCase
Specifies whether text searches should match case.

Return Value

Returns the next or previous cell which meets the specified criteria, or null if no cell is found.
Remarks
Find always searches every cell in this range until it finds the specified text or until it has searched every cell in this range. In other words, Find wraps to the top-left cell in this range and continues searching if needed.
Requirements

Target Platforms: 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

Reference

IRange Interface
IRange Members
Replace Method
FindLookIn Enumeration
LookAt Enumeration
SearchOrder Enumeration
SearchDirection Enumeration