Find Method

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.

[Visual Basic]
Overridable Function Find( _
   ByVal what As String, _
   ByVal after As IRange, _
   ByVal lookIn As FindLookIn, _
   ByVal lookAt As LookAt, _
   ByVal searchOrder As SearchOrder, _
   ByVal searchDirection As SearchDirection, _
   ByVal matchCase As Boolean _
) As IRange

[C#]
virtual IRange Find( 
   string what,
   IRange after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   bool matchCase
);

[C++]
virtual IRange* Find( 
   string* what,
   IRange* after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   bool matchCase
) 

[C++/CLI]
virtual IRange^ Find( 
   String^ what,
   IRange^ after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   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 Type

Returns the next or previous cell which meets the specified criteria, or null if no cell is found.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

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

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.