Perhaps there's a blank row somewhere in the table, that's blocking the
bottom rows from being included.

Remove the AutoFilter (DataFilterAutoFilter)
Then select the entire table, and reapply the filter

doublew wrote:
Hi I have a column of data with different function codes in it. I am trying
to use Auto Filter to pick out all instances of 1 function code, but when I
use the Auto filter function, it doesn't work. It will give me one desired
result at the top of the sheet then the rest is not filtered at all. Any
ideas?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html