title: Excel VBA - Is it possible to use two last row in range select?
body: <p>This involves two last rows so please bear with me, last rows will be different every time.</p>
  <p>I have a large dataset and need to copy formulas from the last row of columns L through AC down to the last row of whatever that happens to be in column A (which Column A last row will always be greater than L). Think of it Columns on the left (A-K) update and columns on right dont update and are left behind so i need to bring columns on right down (these are formulas in these columns).</p>
  <p>Columns A-K last row is 18500
  Columns L-AC last row is 18450</p>
  <p>So i need to &quot;fill&quot; or copy row L18450:Ac18450 down to L18500:AC18500</p>
  <p>Currently I have</p>
  <p><code>dim LLastrow as long</code></p>
  <p><code>dime ALastrow as long</code></p>
  <p><code>LLastrow = Range (&quot;L&quot; &amp; rows.count).end(xlup).row</code></p>
  <p><code>ALastrow = Range (&quot;A&quot; &amp; rows.count).end(xlup).row</code></p>
  <p><code>Range(&quot;L&quot; &amp; LLastrow : &quot;AC&quot; &amp; LLastrow).Select</code>
  but this give me an <strong>ERROR</strong></p>
  <p>The next step would look like</p>
  <p><code>Selection.copy</code></p>
  <p><code>Range(&quot;L&quot; &amp; ALastrow).pastespecial</code></p>