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

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.

Jacques D. wrote:

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

--

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.

Jacques D. wrote:

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

--

Dave Peterson