title: From LastRow to LastRow Offset VBA
body: <p>I am trying to do a <code>AutoFill</code> from the last row to one row below. So <code>LastRow</code> to <code>LastRow Offset (1)</code>.</p>
  
  <p>I know how to find the last row in VBA, but some how I can't find a way to solve this puzzle.</p>
  
  <p>I think It will look something like the following:</p>
  
  <pre><code>LastRow = Cells(Rows.Count, 2).End(xlUp).Row
  LastRow2 = Cells(Rows.Count, 2).End(xlUp).Offset(1)
  
  
  Range("B" &amp; LastRow : "AA" &amp; LastRow).Select
  Range("B" &amp; LastRow2 : "AA" &amp; LastRow2).Autofill
  </code></pre>
  
  <p>If something is not clear please ask, I would appreciate any help</p>