Instead of using one one the list, I use a custom filter.

"Alan" wrote:

I'm not fully sure of you're difficulty here, Autofilter will filter any
range, but only 1000 items will appear in the dropdown list. Could this be
an issue?
Regards,
Alan.
"Raza" wrote in message
...
When I autofilter my database the area selected is rows 2 thru 30,000

cell A2 is CD0000

I filter: greater than CD9999

For some strange reason, everything is filtered out properly except row 2!
What's going on?