title: Autofilter with multi-columns in Excel VBA
body: <p>I need to use VBA to filter some information in excel. As I have an excel with 20 columns, now want to use AutoFilter function to search in some columns if it contains one value (Ex: ID010). what i want is it'll display all rows that have at least one column contains ID010.</p>
  
  <p>Currently, i use the below code to search. However, it could not find any data because all the criteria seem to tie together using AND operator</p>
  
  <pre><code>' Search range, [argIn]---&gt; search value
  With [D5:M65536]
          .AutoFilter Field:=4, Criteria1:=argIn
          .AutoFilter Field:=5, Criteria1:=argIn
          .AutoFilter Field:=6, Criteria1:=argIn
          .AutoFilter Field:=7, Criteria1:=argIn
          .AutoFilter Field:=8, Criteria1:=argIn
          .AutoFilter Field:=9, Criteria1:=argIn
          .AutoFilter Field:=10, Criteria1:=argIn
          .AutoFilter Field:=11, Criteria1:=argIn
          .AutoFilter Field:=12, Criteria1:=argIn
          .AutoFilter Field:=13, Criteria1:=argIn
  End With
  </code></pre>
  
  <p>I wonder if anyone could give me some hints or examples how to handle this issue.</p>
  
  <p>Thank you in advance.</p>