I have an autofilter on a column with 300+ rows.

If I filter on that column, how can I reference/extract the contents of
the very first row returned from the filter even when that first row may
have an 'actual' row number of 178 (or whatever)?

Thanks,

Shane.


--
Shane Moore
------------------------------------------------------------------------
Shane Moore's Profile: http://www.excelforum.com/member.php...o&userid=36421
View this thread: http://www.excelforum.com/showthread...hreadid=571682