Help! Copy row from one workbook and paste into last row of another workbook not working

Hi, I've had the following working before but in another spreadsheet but for some reason it fails in my new spreadsheet. The only difference is that the destination workbook is now macro enabled so maybe has something to do with that?

What I'm trying to achieve is to copy a fixed range of data from one workbook to the last empty row of another workbook. Here is what I've tried:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Thanks!

Hi, Jo2710,

maybe try working with Objects like

Please Login or Register  to view this content.

Ciao,
Holger