The problem that I see with using Row() is that this gives you the row
number of the cell that the formula is in. When what I want is the row
number of where the cursor is at any particular moment.

If the formula is in D3
and the cursor is on A500 then the range I am wanting to find the maximum
value for is C450:C500

if the cursor is on A625 then the range I am wanting to find the maximum
value for is C450:C625

i.e. one part of the range is static and the other part is dynamic according
to the position of the cursor.

Can this be done.

George


"Bob Phillips" wrote in message
...


"George Andrews" wrote in message
...
Bob

Your formula gives me the maximum figure in the range between C450 and
the
Row where the formula is placed. Maybe I did not explain correctly but
I
am
wanting the result to show the maximum in the range between c450 and the
cell that the cursor is in at that moment.

so if I am in A500, then I want the maximum value in the range C450:C500

That is the same thing as I have already given as far as I can see. If you
really mean A450,C500, you have a problem as the formula cell is within
that
range, so you will get a circular reference.