why auto filter does not show all the records in drop down menu ?
why auto filter does not show all the records in drop down menu ?
Hi and welcome to the forum
Do you have empty cells/rows in your range? By default, the filter goes to 1 row above the 1st empty row.
Remove the filter, highlight the entire range, then reset the filter
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It's limited to 10000 items in XL2007 and later, or 1000 in 2003 and prior, if that's what you mean?
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks