Dear Denis
I think he is talking about the action in the MS Object VBO which is apply worksheet filter.
It takes a collection as an input contains 3 columns which is the number of column in excel, the operation and the value.
I also tried to filter with multiple values in the same column, but I don't know the syntax to be written in the value field.
For example, If I had a Column contains values Red, Blue, Green and black. And I want to filter to get only the reds and blacks, What should I do ?
if I added a new row in the collection and put each value in a row, the last row overwrites on the previous one.
I hope that I explained the whole situation to you.
thank you.
------------------------------
Haitham Hassan
------------------------------