'Declaration
 
Function Find( _
   ByVal what As Object, _
   Optional ByVal after As Object, _
   Optional ByVal lookIn As FindLookIn, _
   Optional ByVal lookAt As LookAt, _
   Optional ByVal searchOrder As SearchOrder, _
   Optional ByVal searchDirection As SearchDirection, _
   Optional ByVal matchCase As Boolean _
) As IRange

'Usage
 
Dim instance As IRange
Dim what As Object
Dim after As Object
Dim lookIn As FindLookIn
Dim lookAt As LookAt
Dim searchOrder As SearchOrder
Dim searchDirection As SearchDirection
Dim matchCase As Boolean
Dim value As IRange
 
value = instance.Find(what, after, lookIn, lookAt, searchOrder, searchDirection, matchCase)

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

Parameters

what

The data to search for.

after

The cell after which you want the search to begin. The search begins after this cell; the specified cell isn't searched until the method wraps back around to this cell. If you do not specify this argument, the search starts after the cell in the upper-left corner of the range.

lookIn

The type of data to search.

lookAt

A LookAt value indicates whether a match is made against the whole of the search text or any part of the search text.

searchOrder

The order in which to search the range.

searchDirection

A SearchDirection value indicates whether a match is made against the whole of the search text or any part of the search text.

matchCase

true to make the search case-sensitive.

Return Value

Reference

IRange Interface
IRange Members