Copy paste column

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

Application.DisplayAlerts = False

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