Autofilter will only work on a contiguious range of rows/columns. It will
cease at the first empty row or empty column.........If you must have blank
cells, they can be filled with a single character and set ConditionalFormat
for the same color font as the background.........

hth
Vaya con Dios,
Chuck, CABGx3


"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