GrapeCity.Spreadsheet.IRange.Find

Find Method

Find(object, object, FindLookIn, LookAt, SearchOrder, SearchDirection, bool)

Finds specific information in a range.

Declaration

IRange Find(object what, object after = null, FindLookIn lookIn = FindLookIn.Values, LookAt lookAt = LookAt.Part, SearchOrder searchOrder = SearchOrder.Rows, SearchDirection searchDirection = SearchDirection.Next, bool matchCase = false)

Function Find(what As Object, Optional after As Object = Nothing, Optional lookIn As FindLookIn = FindLookIn.Values, Optional lookAt As LookAt = LookAt.Part, Optional searchOrder As SearchOrder = SearchOrder.Rows, Optional searchDirection As SearchDirection = SearchDirection.Next, Optional matchCase As Boolean = False) As IRange

Parameters

Type	Name	Description
object	what	The data to search for.
object	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.
FindLookIn	lookIn	The type of data to search.
LookAt	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	searchOrder	The order in which to search the range.
SearchDirection	searchDirection	A SearchDirection value indicates whether a match is made against the whole of the search text or any part of the search text.
bool	matchCase	`true` to make the search case-sensitive.

Returns

Type	Description
IRange	An IRange object that represents the first cell where that information is found.