Can you modify this code:
This copies last row into next available row.![]()
Private Sub CommandButton1_Click() Dim lastRow As Long lastRow = ActiveSheet.Range("A1").SpecialCells(xlCellTypeLastCell).Row Rows(lastRow).Copy Destination:=Rows(lastRow + 1) End Sub
Bookmarks