title: Excel VBA Range.AutoFilter filtering for equal sign ("=")
body: <p>I hava a table <code>tbl_recommendations</code> that contains the following values in column 13: <code>--</code>, <code>-</code>, <code>=</code>, <code>+</code>, <code>++</code>.</p>
  
  <p>Now, I would like to filter for <code>=</code>, <code>+</code>, <code>++</code>. This is working fine manually, however, I am facing some problems when using VBA regarding filtering for <code>=</code>. Simply using the macro recorder, it gives me the following code:</p>
  
  <pre><code>Sub Test()
  
  ActiveSheet.ListObjects("tbl_recommendations").Range.AutoFilter Field:=13, _
      Criteria1:=Array("+", "++", " = "), Operator:=xlFilterValues
  
  End Sub
  </code></pre>
  
  <p>When executing this macro, it only filters for <code>+</code> and <code>++</code>, but not for <code>=</code>. What's the trick?</p>