ActiveSheet.Range("$A:$IP").AutoFilter Field:=45, Criteria1:Array("<>COM", "<>", "<>RES"),_ Operator:=xlFilterValues
            Asked
            
        
        
            Active
            
        
            Viewed 11 times
        
    ActiveSheet.Range("$A:$IP").AutoFilter Field:=45, Criteria1:Array("<>COM", "<>", "<>RES"),_ Operator:=xlFilterValues