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