03-10-2001, 08:57 AM
|
|
|
Re: MAX Function in a Macro
|
You can use any worksheet function, including MAX, in VBA by preceeding the function name with "Application.Worksheetfunction." For example,
Maximum = Application.Worksheetfunction.Max(Worksheets("Sheet1").Range("F23:O25" ))
This would set the variable "Maximum" to the max value of the specified cell range on Sheet1.
RDH
|
|
MAX Function in a Macro
Linear Mode
