Autofilter on multiple condition using an Array

[Ricco Balboa]

Hello

Its pretty much in the header, I need to select multiple criteria in an autofilter, I have found the best way to do this is in an array. I can add the array but i'm struggling to add the conditions to the array within the criteria.

here is my example:

Please Login or Register  to view this content.

Please can someone help me?

Thanks
Ricco

[romperstomper]

Your array declaration should be:

Please Login or Register  to view this content.

and the filter line should be:

Please Login or Register  to view this content.

[Ricco Balboa]

In my country we would call you a "Legend"

Thank you very much.

[romperstomper]

You're welcome.
In my country, I get called a lot of things - that's not usually one of them.

[Ricco Balboa]

Were probably in the same one to be honest, you've saved my bacon anyway.