Filter values that are not

Hi,

Is there a way to code so that the filter does not include certain values?

This is my code at the moment, but I want the filter exclude values in a column (so not the values below):


ActiveSheet.Range("$A$1:$S$1018").AutoFilter Field:=3, Criteria1:=Array( _
"BABC", "BCBHS", "BCBP", "BCBS", "BCLB"), Operator:=xlFilterValues
ActiveSheet.Range("$A$1:$S$1018").AutoFilter Field:=8, Criteria1:="<>*g*", _
Operator:=xlAnd

Thanks!

Hi..


I just worked on a similar issue today and posted it here.. it might help you..

http://www.mrexcel.com/forum/excel-q...ml#post3507188