Check out ozgrid's site. He has written a function to do this:
http://www.ozgrid.com/VBA/autofilter-criteria.htm

HTH

Die_Another_Day
ah wrote:
Hi,

If I set up an autofilter on a range of cells, how can I display the value
of that autofiler in another cell
--
thanks in advance for you help

ah