title: range.copy Destination "A1" vs "Cells(1,1)" Excel/VBA
body: <p>Consider the below:</p>
  
  <pre><code>    Sheets("X").Activate
      Sheets("X").Range(Cells(1, 1), Cells(1, 30)).Copy Destination:=Sheets("Y").Range("A1") 'Syntax 1
      Sheets("X").Range(Cells(1, 1), Cells(1, 30)).Copy Destination:=Sheets("Y").Range(Cells(1, 1)) 'Syntax 2
  </code></pre>
  
  <p>Why does Syntax 1 works while Syntax 2 runs into 'Application-defined or object-defined error'?</p>