Simon,

I am not sure I get the problem.

I assume that Hols 1 is a range that included those dates between 1/1 and
14/4 that are holidays, 3 or 4 dates say. Similarly Hols2. But where is
Hols1 and Hols2, columns B and C, or all in B, or what? And are you meaning
that you are adding another date to Hols1 that causes the problem?

BTW, are Hols1,2 etc static ranges or dynamic?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Simon Lloyd"
wrote in message
...

Hi all,

Is it possible to have a named range that stays between two dates that
you have in a column? In column A i have all the dates of the year, all
the other columns have named ranges spanning the year in 3 sections i.e
1/1/06 - 14/4/06 is Hols1 15/4/06 - 08/10/06 is Hols2 etc. My trouble
is when a line is inserted into one of the ranges lets say 16/1/06 (not
that is the date causing a problem) the range expands as it should but
it encroaches on the next range by pushing it down the sheet, so the
next named range will actually start one row further down.

is there any way of getting the named range to stay within the dates?

I hope i explained it well enough but if not let me know!

Regards,
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=499325