Dear all,
how to set the array as variable
Cells(1, 1).Value = "10", "11", "12","1", "2", "3"ActiveSheet.Range("$A$1:$M$20000").AutoFilter Field:=3, Criteria1:=Array(Sheets("Summary").Cells(1, 1).Value), Operator:=xlFilterValues
Dear all,
how to set the array as variable
Cells(1, 1).Value = "10", "11", "12","1", "2", "3"ActiveSheet.Range("$A$1:$M$20000").AutoFilter Field:=3, Criteria1:=Array(Sheets("Summary").Cells(1, 1).Value), Operator:=xlFilterValues
Posting Permissions
Reply With Quote