title: How to select a range of the second row to the last row
body: <p>I am currently trying to figure out how to select a range from the second row to the last row, but more specifically between a range of columns. For instance I want to select Range(<code>A2:L2</code>) to the last row of data in the spreadsheet.</p>
  
  <p>I have tried,</p>
  
  <pre><code>Dim Lastrow As Integer
  Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
  
  Range("A2:L2" &amp; Lastrow).Select
  </code></pre>
  
  <p>But this selects from <code>A2:L2</code> all the way down to the bottom of the spreadsheet. I have checked to see if <code>Lastrow</code> was incorrect but I printed it to a cell and the correct count of rows displayed.</p>