SpreadsheetGear
Find Method
See Also  Send Feedback
SpreadsheetGear Namespace > IRange Interface : Find Method

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.
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

Visual Basic (Declaration) 
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# 
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 Value

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

Requirements

Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.