Syntax

expression.WorksheetFunction

expression A variable that represents an Application object.

Example

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

Visual Basic for Applications
Set myRange = Worksheets("Sheet1").Range("A1:C10") answer = Application.WorksheetFunction.Min(myRange) MsgBox answer
apply a worksheet function return worksheetfunction object worksheet worksheet function Worksheet Function Property worksheetFunction worksheetfunction property

See also: