Application.WorksheetFunction property

Returns the WorksheetFunction object. Read-only.

Syntax

expression.WorksheetFunction

expression A variable that represents an Application object.

Example

The following example displays the result of applying the Min worksheet function to the range A1:A10.

Set myRange = Worksheets("Sheet1").Range("A1:C10") 
answer = Application.WorksheetFunction.Min(myRange) 
MsgBox answer