Thanks for your reply Don, but i may not have explained myself well
enough!. The portion of code you highlighted where i have the gb track
is just to track who logged on, the named ranges are on the same sheet
in blocks one after the other like this Hols1 $D$14:$AK$121, Hols2
$D$122:$AK$334, Hols3 $D$335:$AK$416 and the rows that people can add
to these ranges are at the bottom i.e below row 416, they just add a
date and and name and when the program closes it sorts in date order
but when it does this it is not expanding the named range just moving
it by however many entries.

can you help any further?

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=489095