As I understand the description you have now given, you are entering a new
row of data at the very bottom of the data, then sorting the data to get it
into the correct position.

If that is what you are doing, then there is no reason to expect excel to
change the defined name. Inserting data usually refers to selecting a row,
doing Insert=Row. In that case, the ranges (such as you define them) will
adjust (regardless of what is entered in the space).

Your defined name has no understanding of the fact that it marks ranges of
dates - so when you sort in a date, there is no adjustment. To achieve
expansion under those conditions, you would need to build a formula that
determines the extent of the range based on the values in the cells.

--
Regards,
Tom Ogilvy


"Simon Lloyd"
wrote in message
...

Thanks for replying, i'm naming the ranges Hols1, Hols2 and Hols3 in
this format =Holidays!$A$14:$AK$131 (this one is Hols1, the other two
come directly below this one i.e =Holidays!$A$132:$AK$232 etc.), when a
line is taken off the bottom of all these ranges and because of a sort
by date in Auto_close and inserted into one of these ranges my count up
worksheet goes all to pot because of the description i gave in the first
post.

my count up sheet and formulas work fine, its just beacuse its
referencing a named range that is not expanding as it should, i could
mail you the workbook if you would like to see whats happening.

My e-mail simonwlloydATmsnDOTcom

Hope you can help,
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