Shalbriri
Board Regular
- Joined
- Nov 4, 2010
- Messages
- 93
Code:
Sheets("Sheet2").Select
Range("d2:E33").Offset(0, 0).Select
Selection.Copy
Range("D2:E33").Offset(0, 1).PasteSpecial
Range("C2:D33").Offset(0, 0).Select
Selection.Copy
Range("C2:D33").Offset(0, 1).PasteSpecial
since i need to move 2 columns of data to the right, by one step.
![](/board/proxy.php?image=http%3A%2F%2Fimg16.imageshack.us%2Fimg16%2F9920%2Fmovementd.th.jpg&hash=68d17fce90cffa88298a69b2b6c5cc39)
The idea is to move data from C to D to E to F and so on.
but the procedure must be backwards, if you get my point.
http://imageshack.us