title: Excel VBA Copy and Paste to last row
body: <p>A complete beginner with Excel VBA here. I want to be able to copy and paste a chunk of information from one cell in one row to cells in another row. For example a chunk of information from Row "A" to Row "F". However I want to be able to do this multiple times even after i have already run the macro once and i want the information to be pasted below the last used cell of Row "F", so the list can be continued. I want to paste the information with no lines between each column when I run the macro multiple times but I want it to start from a specific column. However I can't seem to do it.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Sub pastebelowlastcell()
  Dim lRow As Long
  Dim LastRow As Long
  lRow = Sheets("Sheet1").Cells(Rows.Count,"A").End(xlUp).Row
  lRow = lRow + 1
  LastRow = Sheets("Sheet1").Cells(Rows.Count,"F").End(xlUp).Row
  LastRow = LastRow + 1
  ActiveSheet.Range("A1:C" &amp; lRow).Copy
  ActiveSheet.Range("F" &amp; LastRow).PasteSpecial
  Application.CutCopyMode = False
  End sub
  </code></pre>
  
  <p>For example, I want to paste the code starting from "F10" but if i change my code to:</p>
  
  <pre><code>LastRow = Sheets("Sheet1").Cells(Rows.Count,"F").End(xlUp).Row
  LastRow = LastRow + 9
  </code></pre>
  
  <p>It will paste starting from "F10", but it will paste with 8 blank lines in between each time it pastes, when I run the code multiple times.</p>
  
  <p>Also, is it possible to be able to paste the information from single cells into merged cells using this method?</p>