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!!

--
Message posted from http://www.ExcelForum.com

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"paritoshmehta " wrote in
message ...
hi,

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

i hope i am making sense....

thanks for any help possible!!!


---
Message posted from http://www.ExcelForum.com/