Hi I want to copy and paste a column of data using visual basic onto another
data sheet in the same workbook. So that comums run accross the paste sheet
left to right.
I have done this copy and past one column but the next pastes over the last
on the second sheet.

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

baz wrote:

Hi I want to copy and paste a column of data using visual basic onto another
data sheet in the same workbook. So that comums run accross the paste sheet
left to right.
I have done this copy and past one column but the next pastes over the last
on the second sheet.

Hi, baz.

Try

Sub bazcopy()

With ActiveSheet
Worksheets(.Index + 1).Columns("A:A").Value = _
.Columns("A:A").Value
End With

End Sub


()---cucchiaino
www.riolab.org