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")
Any help would be appreciated.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
Thanks,
Met
Bookmarks