Names and changing cell ranges
 

Hi,

I am building mulitple Charts which over time need to be quickly updated
when the input cell ranges change. I am using Names for the ranges. I am
looking for a quick way to redefine the cell range which each Name refers to.
I know I can do this in the "Refers To" box, but is there a way to pass along
the max and min cell range? I have a lot of Named ranges and it would be
great if they could just grab the needed values from a couple of rows.

Names and changing cell ranges
 

Hi,

Dynamic Range Names may be helpful.

these involve names which use formulas in the Refers to box. For example

=OFFSET(Sheet1$A$1,0,0,COUNTA(Sheet1!$A$1:$A$100))

Here the number of entries in column A down to row 100, assuming they are
entered without skipping lines, indicates how large a range the range name
refers to. And here is another example

=OFFSET('Running Totals'!$C$4,0,0,,COUNTA('Running Totals'!$C$5:$N$5))

In the second case the number of entries on row 5 determines how can cells
on row 4 are included in the name.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Harold Christian" wrote:

Hi,

I am building mulitple Charts which over time need to be quickly updated
when the input cell ranges change. I am using Names for the ranges. I am
looking for a quick way to redefine the cell range which each Name refers to.
I know I can do this in the "Refers To" box, but is there a way to pass along
the max and min cell range? I have a lot of Named ranges and it would be
great if they could just grab the needed values from a couple of rows.