title: Insert 2 rows 5 rows before end
body: <p>I am trying to have a macro, on command, find the last used cell in Column A and then insert 2 rows before the 5 rows preceding that last cell.</p>
  
  <p>I have found the following code on stackoverflow for finding the last used cell, but have not been able to use this to add 2 rows.  </p>
  
  <pre><code>Dim LastRow As Long
  ' Find the last row in column "C" (pass in whatever column you want, obviously)
  LastRow = Range("A" &amp; ActiveSheet.Rows.Count).End(xlUp).Row
  rw = LastRow - 5
  </code></pre>