Finds specific information in a given range and returns a Range object that represents the first cell where that information is found. Returns Nothing if no match is found. Does not affect either the selection or the active cell.
Syntax
expression.Find(What, After, FindLookIn, FindLookAt, SearchOrder, SearchDirection, MatchCase)
expression An expression that returns a Range object.
What Required Variant. The data to be searched for.
After Optional Variant. Specifies the cell after which the search begins. If this argument is not specified, the search begins after the active cell.
FindLookIn Optional SheetFindLookInEnum constant. The default constant is ssValues.
FindLookAt Optional SheetFindLookAtEnum constant. The default constant is ssPart.
SearchOrder Optional SheetSearchOrderEnum constant. The default constant is ssByRows.
SearchDirection Optional SheetSearchDirectionEnum constant. The default constant is ssNext.
MatchCase Optional Boolean. The default value is False.