Good morning

First,English is not my language.Then, I make an apology for my
mistakes.
Here's my excel project vba. I have a table and I want to create some
lists. In fact, I want one list for each filter. If I have five
filters, I want to print five lists.
It is just an example. The number of the filters can be high:
50,etc...I don't know beforehand this number.The other difficult is
that I want to put my filter in different columns.
For example,I have a filter in the first column. I will have five
lists. After, I put a filter in the third column and I will have three
other lists.The result is eight lists.
I have used the recorder:
Selection.AutoFilter Field:=1, Criteria1:="My first filter"
Selection.AutoFilter Field:=1, Criteria1:="My second filter"
........
And I begin again with my third column.

But, if the number of filters is high, it's too long. How can I put all
filters in my code without write them one by one? I want to print all my
lists in one time.

Thanking you in advances for your help


--
Raiby
------------------------------------------------------------------------
Raiby's Profile: http://www.excelforum.com/member.php...o&userid=37755
View this thread: http://www.excelforum.com/showthread...hreadid=573382