title: Excel error 400 when copying to a different sheet
body: <p>I have looked at 100 different solutions for fixing this error that keeps showing up. its a pop up box with only the number "400" and an OK button.</p>
  
  <p>the sheet im copying from is called "Front End"</p>
  
  <p>My code looks like this:</p>
  
  <pre><code>Sub transfer()
  
  range("C2").Select
  Selection.Copy
  Worksheets("Raw Data").Select
  lMaxRows = Cells(Rows.Count, "A").End(xlUp).Row
  range("A" &amp; lMaxRows + 1).Select
  Selection.Paste
  
  End Sub
  </code></pre>
  
  <p>Im just trying to get the hang of moving data from one sheet to the next empty row in another sheet but keep getting this error. any help would be greatly appreciated as I am extremely new to VBA</p>