Export (0) Print
Expand All
Expand Minimize

Application.WorksheetFunction Property

Office 2007
Returns the WorksheetFunction object. Read-only.

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



Community Additions

ADD
Show:
© 2014 Microsoft