title: Just-recorded macro fails to execute - AdvancedFilter method of Range class failed
body: <p>I am working with Microsoft Office 2010.</p>
  
  <p>I want to create a button that refreshes an 'AdvancedFilter' upon click.<br>
  What I did is to record a macro in order to replay my actions.<br>
  But the macro fails already at its first execution.  </p>
  
  <pre><code>Sub Test()
  '
  ' Test Macro
  '
  
  Workbooks("requirement_spec.xls") _
      .Sheets("Requirements").Range("A4:BU279").AdvancedFilter _
          Action:=xlFilterCopy, _
          CriteriaRange:=Range("A1:F5"), _
          CopyToRange:=Range("A11:BU11"), _
          Unique:=False
  End Sub
  </code></pre>
  
  <p>Starting the macro via Excel's macro menu or via a button results in this error:</p>
  
  <blockquote>
    <p>Run-time error '1004':<br>
    AdvancedFilter method of Range class failed</p>
  </blockquote>
  
  <p>I didn't change a character of the automatically recorded macro when producing the error message.<br>
  (I just did some line-breaking changes for SO)</p>