title: AutoFilter.ShowAllData "Object Required" Error?
body: <p>I'm attempting to select all in the AutoFilter and am using ShowAllData, it works however each time it gives an error "Object Required"?</p>
  
  <pre><code>Sub FilterAll()
  
  Worksheets("Report").Range("A1:D1").AutoFilter.ShowAllData
  
  End Sub
  </code></pre>
  
  <p>This doesn't work either:</p>
  
  <pre><code>Sub ShowAll()
  
  Worksheets("Report").ShowAllData
  
  End Sub
  </code></pre>
  
  <p>With that I get an error 1004: ShowAllData method of Worksheet class failed.</p>
  
  <p>I am setting the filter first with a subroutine:</p>
  
  <pre><code>Sub Show1B()
  
  Worksheets("Report").Range("A1:D1").AutoFilter _
      Field:=4, _
      Criteria1:="1B"
  
  End Sub
  </code></pre>
  
  <p>And then want to "Select All" (so to speak) with the filter with the FilterAll Subroutine</p>