title: Copy Range until lastRow and paste in another worksheet
body: <p><strong>I'm presently using the below code to copy paste the range, but it creates a really large file once the data is pasted, how can I modify this to copy paste only till the last active row? Or is the file getting big because of some other factor?
  New to VB, any help would be much appreciated.</strong></p>
  
  <pre><code>Private Sub CommandButton1_Click()
  Dim WB1 As Workbook
  Dim WB2 As Workbook
  
  Set WB1 = ActiveWorkbook
  Set WB2 = Workbooks.Open(WB1.Path &amp; "\RawData.xlsm")
  
  WB1.Sheets("CR Details").Columns("A:AW").Value = WB2.Sheets("sheet1").Columns("A:AW").Value
  
  WB2.Close
  End Sub
  </code></pre>