Macro will not move copied data to next blank row?

Hello,

Ive playing with various different Macro designs with information here on the Excel forum to copy the values of Row 8 into a selection of Rows further down the spreadsheet (Rows 70-121)

The aim of the Macro is to copy Row 8's data into the next empty row below the last Macro'd Row, however whichever way i go about it all it seems to do is overwrite the 1st Row of copied data.

Some of the Macro's i have built/tried;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any help as to where im going wrong would be very much appreciated!

Thanks,

Macro Newb Dave

Moderators Note: Please follow Forum Rule #3 about the use of code tags. Added for you this time, but please use them in the future…Thanks.

Try this

Please Login or Register  to view this content.

Or this also

Please Login or Register  to view this content.

Hi Dave,

Moderators Note: Please follow Forum Rule #3 about the use of code tags. Added for you this time, but please use them in the future…Thanks.

You were wanting to copy entirerow 8 and paste into column B. That would never work. You would need to paste into column A.

Please Login or Register  to view this content.