WorksheetFunction.Find Method

Excel Developer Reference

Finds specific information in a worksheet.

Syntax

expression.Find(Arg1, Arg2, Arg3)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data Type Description
Arg1 Required String The name of the worksheet.
Arg2 Required String The name of the range.
Arg3 Optional Variant The name of an argument to refine the search.

Return Value
Double

Reference
Split Text from One Cell into Multiple Cells Using WorksheetFunction.Find

See Also