Using for loops for lateral printout of data instead of vertical

[jebenexcel]

Say you have a for loop that posts stuff for each iteration into cells one below each other. That's pretty easy to do, with say "A" + i.
How does one go about doing this with the cell letters, or in other words to put stuff into cells to the side using for loops?

Cheers

 

[Fluff]

Something like this

Sub tst()
   Dim i As Long
   
   For i = 1 To 10
      Range("A1").Copy Cells(6, i)
   Next i
End Sub

 

[Norie]

Instead of using Range, which is what I assume you would use with "A" & i, you would use Cells.

With Cells you can use either the letter or number to specify the column.

 

[jebenexcel]

So range.A1 would be Cells.C1R1?