Using WorksheetFunction.Max()
try this
WorksheetFunction.Max(range("Line"))
--
Gary
"Dave" wrote in message
...
I have a worksheet where A1:A10 is a named range "Line"
and C1:C10 is named "Qty".
Each cell in "Line" has the formula =IF(ISNUMBER(Qty),ROW(),"")
The worksheet function =Max(Line) will return the highest value in the range
"Line".
When I try to use WorksheetFunction.Max(Line) in VBA, it always returns 0
(zero).
How can I correctly use the code to match the results of the worksheet
function?
Thanks very much.
|