you're welcome .. .it is definitely a useful function - use it for all my
data validation lists / pivot table sources and Debra's explaination is
really helpful too, isn't it?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Nort" wrote in message
...
JulieD,

That hit the nail on the head. Why didn't I know about offset() before!
What a useful function. Thanks again.

MN

"JulieD" wrote:

Hi Nort

frustration isn't it ... check out "dynamic ranges, naming" at
www.contextures.com/tiptech.html
for an solution

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Nort" wrote in message
...
I add new data to the data range weekly. To get the (6) pivot tables
which
look at the data to update and include the new lines, I have to go into
the
wizard and redefine the data range for each pivot. There must be an
easier
way.