WorksheetFunction Property [Excel 2003 VBA Language Reference]

  • Article

Returns the WorksheetFunction object. Read-only.

Example

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

Applies to | Application Object