ILoveCheese
New Member
- Joined
- Mar 27, 2008
- Messages
- 27
I am trying to learn how to use loops in regards to copying and pasting data. If I have a range of data, C10:C15, how do get that to paste to D10:D15? I don't want to copy the whole range all at once. I would like to learn how to offset the data instead. I tried putting some code together from what I've seen on the board, but its not getting me anywhere.
Dim M As Integer
For M = 1 To 5
Range("C10").Copy Destination:=Range("D10")
ActiveCell.Offset(1, 0).Select
Next M
End Sub
I don't know how to finish this so the paste destination offsets like the copy location.
Dim M As Integer
For M = 1 To 5
Range("C10").Copy Destination:=Range("D10")
ActiveCell.Offset(1, 0).Select
Next M
End Sub
I don't know how to finish this so the paste destination offsets like the copy location.