Find first empty cell in a row and insert date and time

[Mesktomten]

Hi!

I've made a macro that selects an entire row from one sheet and inserts into first empty row on another sheet. After I've done this I would like the first empry cell in the "new row" to contain the date and time of creation, but I can't seem to figure this out.

This is the code I'm currently using:

Please Login or Register  to view this content.

Thank you!

/Martin

[davesexcel]

Try this

Please Login or Register  to view this content.

[JBeaucaire]

With the OP on Excel 2007, we should not limit the macro to Excel 2003 rows. To make it work properly in either, adjusted like so:

Please Login or Register  to view this content.