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