WorksheetFunction.Find (Excel)

Finds specific information on a worksheet.

Find (Arg1, Arg2, Arg3)

Dim strArg1 As String: strArg1 = 
Dim strArg2 As String: strArg2 = 
Dim dblFind As Double
dblFind = WorksheetFunction.Find(Arg1:=strArg1, Arg2:=strArg2)

Arguments

Arg1 (String) - The name of the worksheet.

Arg2 (String) - The name of the range.

Arg3 - The name of an argument to refine the search