WorksheetFunction Object [Excel 2003 VBA Language Reference]
Application![]() |
Used as a container for Microsoft Excel worksheet functions that can be called from Visual Basic.
Using the WorksheetFunction Object
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.
Set myRange = Worksheets("Sheet1").Range("A1:C10")
answer = Application.WorksheetFunction.Min(myRange)
MsgBox answer
Properties | Application Property | Creator Property | Parent Property
Methods | Find Method | Replace Method | RTD Method | Subtotal Method | Text Method
Parent Objects | Application Object
Child Objects