Hello Mike-

Are you taking into consideration that the AutoFilter List only shows
_Unique_ occurrences of the values in the column? i.e., no matter how may
times 'xxx' appears in your data, 'xxx' will only show up once in the list.

Regards |:)

"mikebo" wrote:

I have a sheet with several hundred lines. When I activate Autofilter, I am
missing some entries in the value list. I can clearly see them in the sheet,
but not in value list. Is this a bug, and is there perhaps a fix? I am using
Excel 2000 SP3.

mike