I need to filter column S in a spreadsheet. I need the filter to display only cells containing "SSD", "CSSD", or "HLND". The following code returns only cells containing all of the values. (Code treats as: "SSD" AND "CSSD" AND "HLND" I need: "SSD" OR "CSSD" OR "HLND")

Sub AutofilterSSD()
Dim rg As Range
Set rg = Range("S9")
rg.AutoFilter
Set rg = Range(rg, Cells(Rows.Count, rg.Column).End(xlUp))
rg.AutoFilter Field:=19, Criteria1:=Array("*SSD*", "*CSSD*", "*HLND*"), Operator:=xlFilterValues
End Sub
Any help would be appreciated.


Thanks,

Met