Hi everyone,

Maybe a slightly bizarre question and I don't know if it's possible or
not.

What I'd like to do is use a value in a cell to be used in as the row
value in an R1C1 function.

e.g.

Column A goes from rows 1 - 47 so I put 47 in a cell and name the cell
"BotRow".

I then have a formula which would be something like:

=sum(R1C1:R"BotRow"C1)

Is there any way of doing this

The actual use of this is so that where I have a whole grid of formulas
and want to change the range they're looking at, I don't have to change
all the formulas, just a value in one cell.

Any help appreciated,

Rob


--
Rob T
------------------------------------------------------------------------
Rob T's Profile: http://www.excelforum.com/member.php...o&userid=28497
View this thread: http://www.excelforum.com/showthread...hreadid=480993