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.