Nel post
*lsilverman* ha scritto:

I have a set of charts that are all drawn from a data set that grows
every day. As it is I need to edit the source data settings every
day to extend the charts by a day every time I update the data.

I'd rather set value of the last row to use in one of the cells of the
spreadsheet, and then use a function to return the correct range
instead of having a fixed range. I tried using the ADDRESS() and
INDIRECT() functions but they only refer to a single cell, not a
range. I can't figure out how to do it, and it's probably something
obvious that I'm just not seeing. I'm familiar with VERY rudimentary
macros & defining my own functions if that would help, but I can't
figure out how to get it to return a range instead of a value.

Lee Silverman

An example of dynamic range is:

=OFFSET($B$2,0,0,COUNT($B:$B),1)

I suggest you also to read Chip Pearson's site at this page:

http://www.cpearson.com/excel/named.htm

where he talk about named ranges and expecially of dynamic ranges.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy