Guest User

Untitled

a guest
Jan 20th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. Sub AddRow()
  2. Dim LR As Long
  3. LR = Range("A" & Rows, Count).End(xlUp).Row
  4. Rows(LR).Copy
  5. Rows(LR + 1).Insert
  6. End Sub
  7.  
  8. Sub AddRow()
  9. Dim LR As Long
  10. LR = Cells(Rows.Count,1).End(xlUp).Row
  11. Rows(LR).Copy
  12. Rows(LR + 1).Insert
  13. End Sub
  14.  
  15. Sub AddRow()
  16. Dim LR As Long, _
  17. Ws As Workseet
  18. Set Ws = ThisWorkBook.Sheets("SheetName")
  19. LR = Ws.Range("A" & Ws.Rows.Count).End(xlUp).Row
  20. Ws.Rows(LR).Copy
  21. Ws.Rows(LR + 1).Insert
  22. End Sub
Add Comment
Please, Sign In to add comment