For example:

=SUM(INDIRECT("B1:B"&A1))

--

Vasant

"Mal" wrote in message
...
I have a range of cells that is ever increasing.
I also have a number of formula that refer to the range.
To save changing the formula every time the range increases in size, I was
wanting to have a single reference cell that I could change to reference
the
extent of the range.
For example:-
Range b1:B5
size of the range increases to B1:b10
I want to put in cell A1, a reference "10" that I can increase as the
range
increases and without having to change the separate formula that refer to
the range.
So the forhula would be something like =B1:B(value(a1).
Any help appreciated.
Thanks,
Mal