Hi Dave thankyou for your response,

sorry to sound daft but when you say select the complete range do you
mean to highlight the column in question from the very top where it has
A B C or which ever particular column it is? or do you mean just
highlight from top to bottom the data to be checked? What exactly is
selecting the entire range?

Also when i opened up the spreadsheet there is no gap but i had to
click on 'ALL' on the filter to bring up the noticeable break in the
list. Why is that?

regards

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