WorksheetFunction Property
TOC
Collapse the table of content
Expand the table of content

Application.WorksheetFunction Property (Excel)

Office 2013 and later
GitHub-Mark-64px

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
Show:
© 2016 Microsoft