Think 1000 is the limit for items to display in the autofilter droplist

Try Debra Dalgleish's coverage on this at her page:
http://www.contextures.com/xlautofilter02.html#Limits
for a possible workaround
(Look under "Limits to Dropdown Lists")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Michael" wrote in message
...
Have a huge file, 29000 rows with 6 columns.

Ran a auto-filter but the filter stops at the "1001" row.

Thought that I was quite familiar with auto-filters until this.

Can anyone please help tell me what's worng or what I should do??


Thanks in Advance

Michael