Using Min(), Max() in Excel VBA?

[davidd31415]

Is there a way to make use of Excel's built in Min and Max functions within a VBA program? I would like the returned value to be stored in an integer, not in a cell.

Thanks,

Dave

 

[handleman]

WorksheetFunction Property

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