Auto filter problem
 

Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.

Thanks if you are able to assist

Martin

Auto filter problem
 

Select the whole range, making sure you include all the rows & columns you need, then select AutoFilter,
--
David Biddulph

"Martin B" wrote in message ...
Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.

Thanks if you are able to assist

Martin

Auto filter problem
 

for your info,
try reading this...

http://office.microsoft.com/training...RP011459661033

happy holidays

"Martin B" wrote:

Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.

Thanks if you are able to assist

Martin