title: Looping through all available autofilter criteria one at a time in vba
body: <p><strong>I was wondering if there was a way to get all the different autofilter criteria in a list in order to iterate through each criteria</strong>, to in the end copy and paste each different table that would appear to a separate sheet as it iterates through.</p>
  
  <p>Ideally this would be run n times:</p>
  
  <pre><code>ActiveSheet.Range(AllRows).AutoFilter Field:=10, Criteria1:=CritVariable
  </code></pre>
  
  <p>Where n is the number of different CritVariables there are.</p>
  
  <p>I'd like to stress that I know how to copy and paste in the macro itself, but I was curious how to iterate through all the different criteria because the criteria could be different depending on the day. If a list of it isn't available how would I best go about iterating through the criteria?</p>