Hmm... that's strange, I tested it and it works fine for me. Are you sure
that row 1001 is completely blank?

Maybe try turning off AutoFilter, then save your spreadsheet, then close.
Open again and reapply AutoFilter.

What version of Excel are you using? Excel 2003 is the only one I have
access to at the moment, so perhaps AutoFilter behaves differently on older
versions? Other than that, I'm not sure why it isn't working for you.

"CDiddy" wrote:


Hi Elkar,

I have tried that, but it still pulls from the entire column.

Any other thoughts? Thanks for the idea.


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