title: Run-Time error '1004 - AutoFilter method of Range class failed
body: <p>I am getting the above error when running the below code. I am very new to VBA and need some assistance in debugging. </p>
  
  <pre><code>Sub TransferTest1()
  
  Dim INQUIRE As Worksheet
  Dim QUOTE As Worksheet
  Dim ORDER As Worksheet
  Dim YString As String
  Dim RecString As String
  
  Set INQUIRE = ActiveWorkbook.Sheets("Inquiries")
  Set QUOTE = ActiveWorkbook.Sheets("Quotes")
  Set ORDER = ActiveWorkbook.Sheets("Orders")
  
  With INQUIRE.Range("A6:K1200")
      .AutoFilter 11, "Y"
      .Offset(1).Resize(, 7).Copy QUOTE.Range("A6")  ' columns A:G
      .AutoFilter
  End With
  
  With QUOTE.Range("A6:N1200")
      .AutoFilter 14, "Rec'vd"
      .Offset(1).Resize(, 7).Copy ORDER.Range("A6") ' columns A:G
      .Offset(1).Resize(, 2).Offset(11).Copy ORDER.Range("K6")  ' columns L:M
      .AutoFilter
  End With
  
  End Sub
  </code></pre>
  
  <p>Thank you for the help in advance!</p>
  
  <p>R. Smithey</p>