Paste Method Example

This example pastes the contents of cell A1 into cells A3, A5, and A7.

Spreadsheet1.Range("a1").Copy
For rw = 3 To 7 Step 2
    Spreadsheet1.Cells(rw, 1).Paste
Next