Instead of selecting the entire columns when setting up the AutoFilter, just
select the cells that you want to be affected. So, highlight from Row 1 down
through Row 1000.

HTH,
Elkar


"CDiddy" wrote:


All,

Thanks in advance for taking a look at my problem. I appreciate it.

I'm trying to figure out how I limit the range that Autofilter
searches. Basically, I have approximately 1000 rows of data, then a
blank row, then a bunch more data beneath. I need to make it, so that
when I click on the arrow, and autofilter for 'top 10', it only gives
me the top 10 results in the upper range of data (the 1000 top rows),
and not the data that is beyond those first 1000 rows.

Is this possible using autofilter? I know I could do with the advanced
filter, but this workbook is used by people who need it to be as simple
as possible.

Thanks for your help.

C


--
CDiddy
------------------------------------------------------------------------
CDiddy's Profile: http://www.excelforum.com/member.php...o&userid=29492
View this thread: http://www.excelforum.com/showthread...hreadid=539366