Maximum number of records in autofilter drowpdown

[woodmatt]

Hi,

I have a rather large worksheet with excerpts from a database table whereby each row is a record. There are 16606 rows (records). I have put an autofilter at the top row but something seems to be wrong. the column I am trying to filter by has unique values for every record so 16606 values. the dropdown seems to be cutting off a lot of these records and I cannot see them.

Does anybody know if there is a maximum number of values that can be included in the list one of these autofilter drop downs?

Is there any way around this?

[mrice]

This may not be the answer to your question, but if there are any blanks, this can cause the autofilter to apparently miss records.

[VBA Noob]

This link may help

http://www.contextures.com/xlautofilter02.html#Limits

VBA Noob

[woodmatt]

Thanks Guys,

the link explained it. I had more than 1000 unique values in the column I was searching.

Matt

[VBA Noob]

Glad you found an answer

We thx you for the feedback

VBA Noob