title: Select all values above second to last row and copy and paste
body: <p>I am trying to work on a procedure to select the second to last row and all rows above it in a worksheet and copy and paste values. </p>
  
  <p>I'm able to find the last row in my spreadsheet and select the entire row but I'm having a hard time offsetting the selected row. I'm getting an error related to the offset parameter.</p>
  
  <pre><code>'Removes formulas above the last line in the Auto Lease Data
  Dim ALR As Long
  Dim ALR2 As Long
  With Sheets("Auto Lease Data")
     ALR = .Range("A" &amp; .Rows.Count).End(xlUp).Row
     ALR2 = .Range("A" &amp; ALR).EntireRow.Select
     .Range(ALR2).Offset(-1).Activate
  End With
  </code></pre>