title: Trying to use a variable for the criteria in autofilter with "not equal" <> and can not get it to work
body: <p>I'm using Excel VBA to filter a list using the "not equals" expression. If I use <code>Criteria1:="&lt;&gt;Bob"</code>, the code runs perfectly, but if I change "Bob" to a variable, the code does not run.</p>
  
  <p>This works:</p>
  
  <pre><code>ActiveSheet.ListObjects("Rpt_AM_04_Sales_ShipTo").Range.AutoFilter Field:=4, _
      Criteria1:="&lt;&gt;Bob", Operator:=xlFilterValues
  </code></pre>
  
  <p>This does not work:</p>
  
  <pre><code>Dim Test_Criteria As String
  Test_Criteria = "Bob"
  ActiveSheet.ListObjects("Rpt_AM_04_Sales_ShipTo").Range.AutoFilter Field:=4, _
      Criteria1:&lt;&gt;Test_Criteria, Operator:=xlFilterValues
  </code></pre>
  
  <p>I expect the code to return a list that has everyone in it except Bob.
  Instead, I get an error message just typing in the code:</p>
  
  <pre><code>Compile error
  Expected: named parameter
  </code></pre>