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