Of course. For example, take Shane's suggestion from your last post, and
replace various parameters with cell addresses or names:
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A$1:$A$100) ,1)
becomes for example
=OFFSET(Sheet1!$A$1,Sheet1!$C$1,Sheet1!$D$1,Sheet1 !$F$1,Sheet1!$G$1)
=OFFSET(Sheet1!$A$1,Sheet1!RowOffset,Sheet1!ColOff set,Sheet1!NumRows,Sheet1!NumCols)
etc.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"Harold Christian" wrote in
message ...
Hi,
I have set up a number of named cell ranges which plot ok in the chart,
but
now I want make global changes in the cell ranges without having to modify
them in the "Refers To" box. I am using Excel 2007. Can I use Named cells
within the Refers To box, ie. calling the new max and min cells and
establishing the range that way?