Wildcars & cell references

[Guest]

Hi, hopefully a quick answer is available to this, just having a mental blank:

This code succesfully finds all values that contain Australia. Easy.

Selection.AutoFilter
Selection.AutoFilter Field:=12, Criteria1:="=*Australia*", Operator:= _
xlAnd

However, i need to filter based on the value of a cell (not always Australia)

Selection.AutoFilter
Selection.AutoFilter Field:=12, Criteria1:="=*C12*", Operator:= _
xlAnd

Would\should\could this work?

 

[Guest]

See your other post.

Regards,

OssieMac