title: Excel VBA Autofilter - Multiple Criteria of "begin with"
body: <p>I'm using vba to autofilter a list in Excel 2010, and would like to autofilter a list based on 3 or more "begins with" criteria (ie. "a*", "b*", "c*"). Unfortunately, as far as I can tell, you can only have two "begins with" criteria using Operator:=xlOr.</p>
  
  <p>The accepted answer for <a href="https://stackoverflow.com/questions/29413433/vba-autofilter-text-filters-with-multiple-criteria-of-begin-with">VBA Autofilter (Text Filters) With Multiple Criteria of &quot;begin with&quot;</a> looks like it would work. However looping through every single item in the list and adding the values to an array, then autofiltering an exact match to those items is cumbersome. Especially with very large lists.</p>
  
  <p>Is there a better way to autofilter more than two "begins with" criteria?</p>