G Guest Jul 26, 2006 #1 I have a table of approx 1200 records and when I use Autofilter to select specifc records the last record in my table always appears.
I have a table of approx 1200 records and when I use Autofilter to select specifc records the last record in my table always appears.
D Dave Peterson Jul 26, 2006 #2 Next time you apply a filter to that range, notice that the dropdown arrow has changed color to blue for that column. And the row indicators for the range that's filtered are blue. But that last row that shows up, but doesn't match the filter as a row indicator of black/normal. This means that that row is not part of the filter range. So remove the data|Filter|autofilter and select all the range and re-apply data|filter|autofilter.
Next time you apply a filter to that range, notice that the dropdown arrow has changed color to blue for that column. And the row indicators for the range that's filtered are blue. But that last row that shows up, but doesn't match the filter as a row indicator of black/normal. This means that that row is not part of the filter range. So remove the data|Filter|autofilter and select all the range and re-apply data|filter|autofilter.
