I have an export (30k+ records) from a database that I try to filter with Advanced Filter.
With Auto filter I see 3 records, but none with Advanced Filter.
Please see the attached file.
What am I missing? Is this a bug in Excel 2007?
Thank you in advance!
Student
I could be mistaken, but I have a feeling I read somewhere that AF has a limit to the number of rows it can handle, I dont remember the limit though
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
1) In G3, you have =+G5, means "=2000521193" as String. It should be simply 2000521193, or =200052119 or even =A5.
2) You have Criteria A2:AL3, but it should be only G2:G3, otherwise it treats all creteria with And operator, so the data needs to be all blanks except Col.G.
@ jindon, I tried with removing the =, didnt change anything. Did not adjust the criteria range though
See the attached
@ jindon, I was not doubting you, it didnt change anything because I had not adjusted the range lol
Hi,
Your code is correct. The issue is just that D3 is not actually empty. If you select D3 and press Delete and then run your existing code, it will filter the same way as the Autofilter.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks. I will use Auto-Filter for future.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks