title: Add two criterias in VBA range filter
body: <p>I am trying to select a range of values based on filter 1 and filter 2 and then delete all those values; so that I am only left with filter1 and filter2 values in column. I am able to add one filter, but I am not able to add two filters. Please help/guide.</p>
  
  <p>Code:</p>
  
  <pre><code>Case "Sheet-1"
                           iCol = 2
                           Rows("4:4").Select      
                           Selection.AutoFilter
                           ActiveSheet.Range("$A$4:$WXR$99999").AutoFilter Field:=iCol, Criteria1:= _
                           "&lt;&gt;*ABC*", Operator:=xlOr, Criteria2:="&lt;&gt;XYZ*"
                           Rows("5:5").Select 
                           Range(Selection, Selection.End(xlDown)).Select
                           Range(Selection, Selection.End(xlDown)).Select
                           Selection.Delete Shift:=xlUp
                           ActiveSheet.Range("$A$4:$WXR$99999").AutoFilter Field:=iCol
  </code></pre>