[]
Finds specific information in a range.
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
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. |