Paste into non adjacent columns

[Even]

Hi there,
I am having problems pasting two nonadjacent columns into a different sheet. When I paste it ends up pasting the same two columns after each other. Does anyone know how to help me with this? I need to paste the columns in A and F.

[vcoolio]

Hello Even,

You may need to split the ranges in the code you have written:-

Please Login or Register  to view this content.

or you could use arrays to do the task:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[kvsrinivasamurthy]

Try this code

Please Login or Register  to view this content.

[Even]

vcoolio: The first one was just like I needed. Thank you.
kvsrinivasamurthy: Yours worked also. Thanks a lot.

[vcoolio]

You're welcome Even. I'm glad to have been able to assist.
Thanks for the rep!

Cheerio,
vcoolio.