i Col A there is data and in Col E the data i want to apply filter like array("A1","A8","A18"), possible?
i can hide rows with VBA but i want to know in this way. please
Code: Select all
Sub nbd()
'xx = Range("data")
xx = Join(Application.Transpose(Selection), ",")
ActiveSheet.Range("a1").AutoFilter field:=1, Criteria1:=xx, _
Operator:=xlFilterValues
End Sub