Autofilter

J

Jacques D.

Hi,
I use the autofilter based on a specific value in a cell. That works fine.
The problem is the following:
I have formulas in the first 1000 rows of the worksheet, and data in only
700 rows. When I filter the a value, the first empty row showed (not part of
filtered region) is 1001. How can I force the filter to be applied to only
the rows containing data (first 700 ones) so the first empty row be 701?
I believe it has to do with the usedrange. How can I specify a different
range?

JD
 
D

Dave Peterson

You could remove the filter, then reapply it to just the rows you want.

But I bet excel knows better than you and would extend the range.

Could you empty (no formulas, no data at all) row 701. Then apply the filter to
rows 1:700?

=====
Personally, this doesn't bother me anymore. I've given up trying to force excel
to do stuff my way and just live with its irritants, er, features.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top