This code will repeat the last row:
![]()
Sub CopyRow() Dim bottomA As Integer bottomA = Range("a" & Rows.Count).End(xlUp).Row Rows(bottomA).Copy Cells(Rows.Count, "A").End(xlUp).Offset(1, 0) End Sub
This code will repeat the last row:
![]()
Sub CopyRow() Dim bottomA As Integer bottomA = Range("a" & Rows.Count).End(xlUp).Row Rows(bottomA).Copy Cells(Rows.Count, "A").End(xlUp).Offset(1, 0) End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks