title: VBA - "does not contain"-filter (excel 2010)
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/7662659/combine-multiple-exclusion-criteria-in-autofilter">Combine multiple exclusion (&lt;&gt;) criteria in AutoFilter</a>  </p>
  </blockquote>
  
  
  
  <p>I'm trying to set up a filter with multiple 'Does not containt' values. I seem to get an error doh every time I try to run it. I've looked up this error and it means that excel didn't find any value's. When I try to run the same code, only with one value, it works fine. Any help/suggestions?</p>
  
  <p>Code with multiple values:</p>
  
  <pre><code>ActiveSheet.Range("$A$1:$J$218").AutoFilter Field:=5, Criteria1:=Array("&lt;&gt;*a*", "&lt;&gt;*b*", "&lt;&gt;*c*"), Operator:=xlFilterValues
  </code></pre>
  
  <p>Code with only one value: </p>
  
  <pre><code>ActiveSheet.Range("$A$1:$J$218").AutoFilter Field:=5, Criteria1:="&lt;&gt;*a*", Operator:=xlFilterValues
  </code></pre>
  
  <p>Greetz
  Bulki</p>