Using Autofilter with VBA
 

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?

Using Autofilter with VBA
 

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

http://www.solutionsvba.com


"Jon Irwin" wrote in message
...
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?

Using Autofilter with VBA
 

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

"Jon Irwin" wrote in message
...
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?


.

Using Autofilter with VBA
 

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

http://www.solutionsvba.com


"Jon Irwin" wrote in message
...
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?


.