Custom option when using Autofilter

[rstone25]

Hi,

Is there a limitation on how many lines can be displayed when you click on Custom in the Autofilter?

I am not getting all the data thats in the spreadsheet in the drop down list.

There are just under 3000 lines in the document.

Thanks

 

[Al Chara]

As far as I know...No. Make sure your constraints are correct.

 

[Mark W.]

No need to repost. See http://www.mrexcel.com/board/viewtopic.php?topic=2296&forum=2&1.