WorksheetFunction Object

  • Article
Excel Developer Reference

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

See Also