title: Resize a selection to last row in data
body: <p>I have an Excel VBA macro that needs to copy the selection from cells <code>A3:K3</code> down to the last row of data in column <code>L</code>. I have this to get the last cell</p>
  
  <pre><code>Dim lastcell As Long
  lastcell = ActiveSheet.Range("L" &amp; cell.Count).End(xlUp).cell
  </code></pre>
  
  <p>I would think I have to then offset to the left one, resize the selection to column a and go up to the last filled in row. There might be different ways of doing this maybe some how saving as a variable the last row in the data the selecting the <code>A3:k3</code> down to that last row.</p>