Hi All,
How should the criteria look for an array that filters all "AMAT2"
See current criteria array with specific AMAT2's:
ActiveSheet.Range("$A$1:$E$1695").AutoFilter Field:=3, Criteria1:=Array( _
"AMAT2-01A", "AMAT2-01B", "AMAT2-01C", "AMAT2-01D", "AMAT2-02A", "AMAT2-02B", _
"AMAT2-02C", "AMAT2-02D", "AMAT2-03A", "AMAT2-03B", "AMAT2-03C", "AMAT2-03D", _
"AMAT2-04A", "AMAT2-04B", "AMAT2-04C", "AMAT2-04D", "AMAT2-05A", "AMAT2-05B", _
"AMAT2-05C", "AMAT2-05D", "AMAT2-06A", "AMAT2-06B", "AMAT2-06C", "AMAT2-06D"),
Thank you all!!
How should the criteria look for an array that filters all "AMAT2"
See current criteria array with specific AMAT2's:
ActiveSheet.Range("$A$1:$E$1695").AutoFilter Field:=3, Criteria1:=Array( _
"AMAT2-01A", "AMAT2-01B", "AMAT2-01C", "AMAT2-01D", "AMAT2-02A", "AMAT2-02B", _
"AMAT2-02C", "AMAT2-02D", "AMAT2-03A", "AMAT2-03B", "AMAT2-03C", "AMAT2-03D", _
"AMAT2-04A", "AMAT2-04B", "AMAT2-04C", "AMAT2-04D", "AMAT2-05A", "AMAT2-05B", _
"AMAT2-05C", "AMAT2-05D", "AMAT2-06A", "AMAT2-06B", "AMAT2-06C", "AMAT2-06D"),
Thank you all!!