Hi All,
The workbook I am attaching has a sheet named "Filtered List". I am trying to use Data and Criteria in "Sheet1" and filtering data to Sheet("FilteredList"). The macro (FilterMe()) was working just fine until I deleted the named range "criteria" in Sheeet1 and renamed it again. I did not make any changes to the relavant macro.
When the FilterBlock in "FilteredList" is left blank it must return 379 records, but now, it is returning just 160. Cant figure out the reason.
Please help.
Thanks
In the Sheet1 criteria range, you use formulas to copy the criteria from the FilterList criteria. Having a null string "" as criteria is not exactly the same as a blank cell. The null string excludes numbers where a truly blank cell does not. In column GD you have numeric values that are excluded because of the null string criteria.
A quick fix is to have the macro copy the criteria instead of formulas.
Please Login or Register to view this content.
Last edited by AlphaFrog; 06-18-2017 at 09:24 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank u AlphaFrog, but ur suggestion does not work
This worked for me using your example workbook.Originally Posted by mayoorsubbu
Please Login or Register to view this content.
Thank u Alpha Frog for the help. The macro is working now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks