This is my current Autofilter VBA for activecell.value:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
ActiveSheet.Range("$A$2:$X$10000").AutoFilter Field:=1, Criteria1:=ActiveCell.Value
End Sub
What I'd like to do is be able to select a range of different values and have excel autofilter all the values together at once and display their matches together. does anyone know a solution for this?
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
ActiveSheet.Range("$A$2:$X$10000").AutoFilter Field:=1, Criteria1:=ActiveCell.Value
End Sub
What I'd like to do is be able to select a range of different values and have excel autofilter all the values together at once and display their matches together. does anyone know a solution for this?
Last edited: