title: Combine multiple exclusion (<>) criteria in AutoFilter
body: <p>I have worked around my issue by using this dirty hack:</p>
  
  <pre><code>    ' Filter managerial functions
      ActiveSheet.Range("$A$1:$BW$2211").AutoFilter Field:=36, Criteria1:="&lt;&gt;Head*", _
      Criteria2:="&lt;&gt;IT*", Operator:=XlAutoFilterOperator.xlAnd
      ActiveSheet.Range("$A$1:$BW$2211").AutoFilter Field:=36, Criteria1:="&lt;&gt;Local Head*", _
      Criteria2:="&lt;&gt;Resp*", Operator:=XlAutoFilterOperator.xlAnd
      ActiveSheet.Range("$A$1:$BW$2211").AutoFilter Field:=36, Criteria1:="&lt;&gt;Team Lead*", _
      Criteria2:="&lt;&gt;XB*", Operator:=XlAutoFilterOperator.xlAnd
  </code></pre>
  
  <p>Is there any way to combine these 3 statements into one line? Excel seems to have a problem as soon as I have a third criteria (Criteria3) in one line. Furthermore, &lt;>Array() seems not to be supported.</p>