help with excel macro

[paritoshmehta]

hi,

i wanted help on writing this code that will reset the last row to
predefined value(the next row)...... like lets say the last cell i
the column A is A25, then the macro will copy the whole row 26 an
paste it to row 25....

i hope i am making sense....

thanks for any help possible!!

 

[Rob van Gelder]

Sub test()
With ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).EntireRow
.Copy .Offset(-1, 0)
End With
End Sub