title: Multiple Filtering in Excel VBA?
body: <p>I'm trying to filter my data using 2 columns and 2 different filter requirements.</p>
  
  <pre><code>    ActiveSheet.AutoFilterMode = False
      ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=5, Criteria1:="yes"
      ActiveSheet.Range("E:E").AutoFilter Field:=1, Criteria1:="Low"
  </code></pre>
  
  <p>If I filter by yes then it work and if I filter by Low it also works.  However if I try and filter range K2-ZZ200 by yes and then Column E by Low it seems to hide everything.</p>
  
  <p>Any ideas?</p>