Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

WorksheetFunction Object

Office 2007
Used as a container for Microsoft Excel worksheet functions that can be called from Visual Basic.

Example

Use the WorksheetFunction property to return the WorksheetFunction object. The following 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

Show:
© 2016 Microsoft