[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IRange.Find

Find Method

Find(object, IRange, FindOptions)

Finds specific information in a range.

Declaration
IRange Find(object what, IRange after = null, FindOptions options = null)
Function Find(what As Object, Optional after As IRange = Nothing, Optional options As FindOptions = Nothing) As IRange
Parameters
Type Name Description
object what

The data to search for. Can be a string, double, DateTime, TimeSpan, bool or int.

IRange after

The cell after which you want the search to begin. This corresponds to the position of the active cell when a search is done from the user interface. Notice that After must be a single cell in the range. Remember that the search begins after this cell; the specified cell isn't searched unless your code wraps back around to this cell. If you do not specify this argument, the search starts at the cell in the upper-left corner of the range when SearchDirection is Next, or at the cell in the bottom-right corner of the range when SearchDirection is Previous.

FindOptions options

The find options.

Returns
Type Description
IRange

A IRange object that represents the first cell where that information is found.