title: Copy a Range From One Worksheet To The Last Row of Data On Another
body: <p>I want to copy a range of cells in column &quot;B&quot; and paste it after the last row of data on an another sheet in the same workbook in the same column. I have the following code but I can't figure out how to actually paste the data.</p>
  <pre><code>Dim lastRow As String
  
  Sheet9.Range(&quot;B2:B100&quot;).Select
  Sheet9.Range(Selection,Selection.End(xlDown)).Select
  Selection.Copy
  
  
  lastRow = Sheet14.Cells(Rows.Count, &quot;B&quot;).End(xlUp).Row + 1
  Sheet14.Range(&quot;B&quot; &amp; lastRow).Activate
  Sheet14.Paste
  </code></pre>