VBA - is it possible to filter multiple (>2) values using wildcards(*) ?

[Judge5]

Hi All!

I would like to apply a filter for multiple values (> 2), but I do not appear to be able to do that if I'm using wildcards. I'm generating a daily report with a list of addresses. Each address is in its own cell and there is not a standardized address, which is why I'm using wildcards to be able to filter by just the country name (e.g. Austria).

I am able to filter for two values using wildcards:
ActiveSheet.Range("C:C").AutoFilter Field:=1, Criteria1:=Array("*Austria*", "*Belgium*", "*Canada*"), Operator:=xlFilterValues _

And I can filter for >2 values if not using wildcards:
ActiveSheet.Range("C:C").AutoFilter Field:=1, Criteria1:=Array("Austria", "Belgium", "Canada"), Operator:=xlFilterValues _

But as soon as I add the wildcards, the filter removes all data and leaves a blank column:
ActiveSheet.Range("C:C").AutoFilter Field:=1, Criteria1:=Array("*Austria*", "*Belgium*", "*Canada*"), Operator:=xlFilterValues _

Does anyone know if this is possible to do? If this can only be achieved using advanced filters, does anyone know the coding to do that?

Would really appreciate any help you can give!!

Thank you,
Joe

 

[Fluff]

Duplicate VBA - Is it possible to filter out multiple (>2) values?

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).