title: Why copy/pasting vs copy pastingspecial have a different coding?
body: <p>Here is some VBA code</p>
  <pre><code>Set L060 = Workbooks(&quot;L060.xlsx&quot;).Worksheets(&quot;Sheet1&quot;)
  Set wsDest = Workbooks(&quot;Variation_week&quot; &amp; WeekFolder &amp; &quot;.xlsm&quot;).Worksheets(&quot;RM consumption&quot;)
  SelectionL060 = L060.Cells(L060.Rows.Count, &quot;A&quot;).End(xlUp).Row
  Adestination = wsDest.Cells(wsDest.Rows.Count, &quot;A&quot;).End(xlUp).Offset(2).Row
  L090.Range(&quot;A2:M&quot; &amp; SelectionL060).Copy _
  wsDest.Range(&quot;A&quot; &amp; Adestination)
  Workbooks(&quot;L060.xlsx&quot;).Close SaveChanges:=False
  </code></pre>
  <p>Why does not <code>L060.Range(&quot;A2:M&quot; &amp; SelectionL060).Copy _ wsDest.Range(&quot;A&quot; &amp; Adestination)</code> work if you don't add the underscore between <code>Copy</code> and <code>wsDest</code> ?
  Actually if you don't add it, there is a space that automatically appears between <code>Range</code> and <code>(&quot;A&quot; &amp; Adestination)</code> making the code fail.</p>
  <p>Whereas <code>L060.Range(&quot;A2:M&quot; &amp; SelectionL060).Copy wsDest.Range(&quot;A&quot; &amp; Adestination).PasteSpecial Paste:=xlPasteValue</code> works fine without any underscore ?</p>