Remove the filter
select the complete range first
then reapply the filter.
strictly_rhythm wrote:
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
--
Dave Peterson