title: Excel Custom Filter with VBA
body: <p>I am trying to filter a Huge list of over 9000 rows.
  Each row is an individual project and
  all the rows are located in a table, &quot;Table2&quot;;
  the Sheet is &quot;Final Data&quot;</p>
  <p>the lower bound is need to filter is &quot;17-0034&quot;;
  the Upper bound is &quot;17-0152&quot;</p>
  <p>How do I filter between these lower &amp; upper bound
  Value is a text field.</p>
  <p>Here is the code</p>
  <pre><code>Private Sub CommandButton2_Click()
  Sheets(&quot;Final Data&quot;).Select
  ActiveSheet.ListObjects(&quot;Table2&quot;).Range.AutoFilter Field:=19, Criteria1:= _
      Array(&quot;Active&quot;, &quot;Completed&quot;, &quot;Main&quot;), Operator:=xlFilterValues
  ActiveSheet.ListObjects(&quot;Table2&quot;).Range.AutoFilter Field:=20, Criteria1:= _
      &quot;RTB&quot;
  
  ActiveSheet.ListObjects(&quot;Table2&quot;).Range.AutoFilter Field:=1, Criteria1:= _
      &quot;&gt;=17-0034&quot;, Operator:=x1And, Criteria2:=&quot;&lt;=17-0152&quot;, Operator:=xlFilterValues
  End Sub
  </code></pre>
  <p>Please note that this question has been solved and the error was a syntax Typo of 1 vs l. I will leave the question to help those who are trying to understand how to create Custom Filters in VBA.</p>