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
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