VBA Autofilter for 3 or more criteria

[StuLux]

I've read several posts about how to use autofilter with more than 2 criteria and the answer seems to be to use an array - I am trying the following but get a Type Mismatch error on the Criteria 2 line?

Criteria1 = "*Meeting 1*"            
Criteria2 = Array("<>*at their Stand*", "<>*Table (TBC)*")

For further clarity the criteria are then used laterin the code as follows:

Sheet1.Range("A1").AutoFilter Field:=SponsorColID, Criteria1:=Criteria1, Criteria2:=Criteria2

 

[Fluff]

You can only use more than 2 criteria if you are doing an exact match.
For partial matches or <> you are limited to two criteria.
One option is to use a helper column with a formula that returns true/false & then filter on that.
And another option would be to have a look at using advanced filters instead.

 

[StuLux]

You can only use more than 2 criteria if you are doing an exact match.
For partial matches or <> you are limited to two criteria.
One option is to use a helper column with a formula that returns true/false & then filter on that.
And another option would be to have a look at using advanced filters instead.

Thank you Fluff - thought I was going mad but you've explained the issue - will investigate advanced filters but will use a helper column for a quick fix, thanks.

 

[Fluff]

You're welcome & thanks for the feedback