Just some thoughts ..

.. the area selected is rows 2 thru 30,000

Try selecting the entire col A (col header assumed in A1),
then autofilter on A1 ..

.. I filter: greater than CD9999

To avoid ambiguity ..
Try a helper col to extract real numbers from col A
=SUBSTITUTE(A2,"CD","")+0
Then autofilter with your criteria pointing to this helper col
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?