title: VBA: How to copy a row and paste the row underneath using the Offset function
body: <p>The offset function is traditionally used for cells but I would like to use it to copy and paste entire rows.  How do you use the offset function for entire rows?  Here is my code, however, it is not working.  Thank you.</p>
  
  <pre><code>Sub Macro()
  
  Rows("2:2").Select
  Selection.Copy
  Offset(1, 0).Select
  Selection.Insert Shift:=xlDown
  Application.CutCopyMode = False
  
  End Sub
  </code></pre>