Copy paste column

If I understand the request why not just use the single line of code

Please Login or Register  to view this content.

Hi, tax112

Your code can be ran but nothing came out, not sure why though? A pop-out box came out which says Do you want to replace the content of destination cells although it's already empty.

Update: and now it currently shows error: subscript out of range

Hi, Richard

Your code shows error: Object required, not sure why either.

Originally Posted by ell_

Hi, tax112

Your code can be ran but nothing came out, not sure why though? A pop-out box came out which says Do you want to replace the content of destination cells although it's already empty.

Update: and now it currently shows error: subscript out of range

Hi, Richard

Your code shows error: Object required, not sure why either.

You'll need to upload the workbook in which you've entered the code I gave you and explain exactly what you do. Have you changed something else perhaps.

Add an additional line of code before the code I gave of

Please Login or Register  to view this content.

That will presumably fix it but it would be good to know why you get the warning in the first place.