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...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=535301