Hi All,
I need to select multiple values as filter in a column.
If I use this VBA code for a single selection the code works well.
Dim Parameter As Variant
Parameter = "" & "ARGES SPA"
Selection.AutoFilter
Sheet1.Range("$A$1:$AE$24").AutoFilter Field:=3, Criteria1:=Array( _
Parameter), Operator:=xlFilterValues
If I try to set multiple selections, the filter doesn't filer values. More exactly
Parameter = "" & "ARGES SPA" & """ ,""" & "CEATIM SRL" & ""
Any suggestion well be greatly appreciated.
Thanks in advance for your kind support.
Regards,
Giovanni
I need to select multiple values as filter in a column.
If I use this VBA code for a single selection the code works well.
Dim Parameter As Variant
Parameter = "" & "ARGES SPA"
Selection.AutoFilter
Sheet1.Range("$A$1:$AE$24").AutoFilter Field:=3, Criteria1:=Array( _
Parameter), Operator:=xlFilterValues
If I try to set multiple selections, the filter doesn't filer values. More exactly
Parameter = "" & "ARGES SPA" & """ ,""" & "CEATIM SRL" & ""
Any suggestion well be greatly appreciated.
Thanks in advance for your kind support.
Regards,
Giovanni