Hi
I am trying to achieve multiple selection using VBA macro in autofilter but its not working as it should.
Below macro is working fine when there is two values.its not working more then two values.
Can please someone tell me what i am missing.
Sub Macro1()
'
' Macro1 Macro
'
'
Columns("A:A").Select
Selection.AutoFilter
Range("A1").Select
ActiveSheet.Range("$A$1:$A$11076").AutoFilter Field:=1, Criteria1:=Array( _
"=*value1)*", "=*value2*", "=*value3*", "=*value4*"), Operator:=xlFilterValues
End Sub
Bookmarks