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