'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)

IRange Find( 
   System.string what,
   IRange after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   System.bool matchCase
)

function Find( 
    what: System.String;
    after: IRange;
    lookIn: FindLookIn;
    lookAt: LookAt;
    searchOrder: SearchOrder;
    searchDirection: SearchDirection;
    matchCase: System.Boolean
): IRange; 

function Find( 
   what : System.String,
   after : IRange,
   lookIn : FindLookIn,
   lookAt : LookAt,
   searchOrder : SearchOrder,
   searchDirection : SearchDirection,
   matchCase : System.boolean
) : IRange;

IRange* Find( 
   System.string* what,
   IRange* after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   System.bool matchCase
) 

IRange^ Find( 
   System.String^ what,
   IRange^ after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   System.bool matchCase
) 

Parameters

what

Specifies the text to find.

after

Specifies the 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

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

Reference

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