Thanks Bob, but its because the calculations are changing because if
have defined hols1 as eg D1:K20 and insert a line the range should no
expand to D1:K21 but its staying as D1:K20 so the last row has moved ou
of the area that is x8 into the area thats x12, if it could make th
range expand to D1:K21 and each of the others still cover the date
they were ranged for until they have one added and their range expan
down by one......i very much doubt im being clear with my explanation.
If you would like to see the workbook and what i have done with it you
more than welcome.

Thanks,

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=49932