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