Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
WorksheetFunction Property
Collapse the table of content
Expand the table of content

Application.WorksheetFunction Property (Excel)

Returns the WorksheetFunction object. Read-only.

expression .WorksheetFunction

expression A variable that represents an Application object.

This 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
© 2015 Microsoft