title: Set AutoFilter in Excel with VBA
body: <p>Can anyone explain why the first "AutoFilter" statement in the code below continually gives "AutoFilter Method of Range Class Failed" in Excel 2010?</p>
  
  <pre><code>ActiveSheet.AutoFilterMode = False
  shtUSR.Range("A1").Select
  ActiveSheet.Range("A1").AutoFilter Field:=1, VisibleDropDown:=True
  ActiveSheet.Range("B1").AutoFilter Field:=2, VisibleDropDown:=True
  ActiveSheet.AutoFilterMode = True
  </code></pre>