George,
Why not just
=MAX(INDIRECT("plan!C450:C"&ROW()))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"George Andrews" wrote in message
...
Excel 2000
Can anybody correct this formula which is not working for me.
=MAX(C450:INDIRECT("plan!C"&ROW(cell("rows")))
I am trying to get the maximum value from the range C450 and the
Activecell
Row in column C
thanks.
George
|