Hello Valery
See VBA help on object "Filters" , a sample code is supplied there.

HTH
Cordially
PAscal

"Valery" a écrit dans le message de news:
...
Hello.
I nee a help.
Some days i in searches of the decision of this'
I don't know How to get list all criteria currently avaliable for any
columns where is autofilter. Exel as that does it :( I don't know how do
it.
I need this to read all avaliable values and write in to range.
Thx