thanks Dann and Dave for your help.

Yes now I see the rows are blue up to the point where there is a break
in the numbers. It gets to 64 but there is no 65 and that is where the
range goes all funny. Now Ive tried to insert a new row ie: row 65 but
it replaces the one below it so if i put in 65 there is no 66 if you
understand.

I think its fair to say it wasnt a bug, thank goodness.

what shall i do from here?

Many thanks

Steve


--
strictly_rhythm
------------------------------------------------------------------------
strictly_rhythm's Profile: http://www.excelforum.com/member.php...o&userid=36002
View this thread: http://www.excelforum.com/showthread...hreadid=557886