As long as you insert rows within the boundaries of the named range, it
should expand just like any other formula would.

How are you defining the range/name.

--
Regards,
Tom Ogilvy

"Simon Lloyd"
wrote in message
...

Hi all,
Anyone know how to get a named range to expand and contract to keep it
within dates in column A?, i have 3 named ranges on a w/s the first
spans dates 1/1/06 - 14/4/06 and the other 2 are segmented for the rest
of the year, when i insert another row/second occurance of a date in
this range the named range stays for the range set and the last row of
the range is pushed down i.e if 14/4/06 was row 123 then it will now be
124 but the named range still only covers rows 1 - 123.

This is why i would like the named range to expand to cover the added
row/date or contract if i remove a row/date.

Any ideas?

All help appreciated,

thanks
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=504473