I've had similar problem limiting the rows to filter.

I found by chance this workaround:
Name the rows or range of cells to filter (insert, name, cells, range)
Select the range that you just created in the range name box to left of
formula bar
( I also clicked/highlighted the range name but not sure if this is
significant)
now create auto filter
Save the worksheet
Now use autofilter dropdown list

I also found that it takes a few blank rows after the range list before the
next non- blank line. This was due to my using a lot of blank cells and lines
in the range I think.

Hope this helps...........

SWURST


"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