Hi Baz,

Can you please provide a little more detail/clarity on what you want to do?
eg please include the problematic code...

If the columns you are copying are not side by side (eg columns A,C & E, rather than columns A,B & C) but you want them to be pasted side by side in the new sheet try adapting the following:

Sheets("Sheet2").Range("A:c, f:f").Copy Sheets("Sheet3").Range("a1")

However, if you want them to be pasted in the same relative locations that they currently exist in the original sheet, have a look at John W's "Copy multiple selections" at:
http://www.j-walk.com/ss/excel/tips/tip36.htm

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...