Hi,
I have looked almost EVERYWHERE to try and solve my problem but it seems that other solutions are not relevant for the task I am trying to do.
I have a button in a worksheet called Properties which I want to copy the row of the selected cell into the first blank row in a worksheet called Archive.
I have called the row of the active cell Current Row.
All I need is a simple code to copy the CurrentRow from the Properties sheet to the last row in the Archive sheet.
Any help would be great
Bookmarks