Collapse the table of content
Expand the table of content
Expand Minimize

Application.WorksheetFunction Property (Excel)


Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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