IRange.Find Method

Article
01/20/2015

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Find ( _
    What As Object, _
    After As Object, _
    LookIn As Object, _
    LookAt As Object, _
    SearchOrder As Object, _
    SearchDirection As XlSearchDirection, _
    MatchCase As Object, _
    MatchByte As Object, _
    SearchFormat As Object _
) As Range
'Usage
Dim instance As IRange
Dim What As Object
Dim After As Object
Dim LookIn As Object
Dim LookAt As Object
Dim SearchOrder As Object
Dim SearchDirection As XlSearchDirection
Dim MatchCase As Object
Dim MatchByte As Object
Dim SearchFormat As Object
Dim returnValue As Range

returnValue = instance.Find(What, After, _
    LookIn, LookAt, SearchOrder, SearchDirection, _
    MatchCase, MatchByte, SearchFormat)

Range Find(
    Object What,
    Object After,
    Object LookIn,
    Object LookAt,
    Object SearchOrder,
    XlSearchDirection SearchDirection,
    Object MatchCase,
    Object MatchByte,
    Object SearchFormat
)