Hi Stefan

You must use Advanced Filter to get the unique list
I use in the code example below for example
http://www.rondebruin.nl/copy5_3.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"stefan onken" wrote in message ...
hi all,
Autofilter in XL2007 presents a unique list of items in the Autofilter-
Range.
using VBA, i want to get the checked items in this list.
I tried AutoFilter.Filters(1).Criteria1 and Criteria2 and got the
first 2 Criteria.
But how can i get the other Criteria ?


thanks
stefan