Hello,
I would like to create a macro that can add a new row after the last cell. For example, the current row with data is A5, I want to add a new row after A5 is A6, another new row after A6 is A7 and so on. The script below keep adding a blank row right after row 5 instead of one-off. Would anyone be able to fix this? Thank you in advance for your help!
With ActiveSheet
LR = 5
.Rows(LR).Insert Shift:=xlDown
.Rows(LR - 1).Copy
.Rows(LR).PasteSpecial xlFormats
End With
Application.CutCopyMode = 0
Application.ScreenUpdating = True
Bookmarks