Using Autofilter with VBA

[Jon Irwin]

I need to access the items in an Autofilter dropdown in
succession. They must be stored somewhere! All I can get
is 'Criteria1' and 'Criteria2'. Is there something else?

 

[Jean-Paul Viel]

Hi,

You must make your own list of elements because Microsoft doesn't tell where
it is. Collection is the best tool to do that.

 

[Jon Irwin]

Tom

Many thanks

Jon

-----Original Message-----
the items in the autofilter dropdown are not accessible.

you can use the uniqueonly option of the advanced filter to put a unique
list of items from a column in a table on the worksheet.

--
Regards,
Tom Ogilvy

else?


.

 

[Jon Irwin]

Jean-Paul

Many thanks

Jon

-----Original Message-----
Hi,

You must make your own list of elements because Microsoft doesn't tell where
it is. Collection is the best tool to do that.


--
JP
(e-mail address removed)
http://www.solutionsvba.com


else?


.