Is it possible to loop  through three columns at
the same time and copy  the cells  and pasteto another sheet..For
example

Copy A1,B1 and C1 to one sheet, the loop down to A2, b2,c2 copy to
another sheet, down to A3,b3,c3 and copy etc..


I have been trying the code below.. but i know this isnt right as i
have the cll fixed at A1:C1 while it should really be changing as i
go down the loop..


Dim cll As range

set cll As bWkb.Worksheets("Sheet1").Range("A1:C1")

For Each cll In bWkb.Worksheets("Sheet1").Range("A1:C100")

If cll <> "" Then Wkb.Worksheets("Sheet1").Range("c13:e13") =
bWkb.Worksheets("Sheet1").Range("A1:C1")

Next cll