Copy and Paste cell

Solved/Closed
yizsteph Posts 2 Registration date Thursday December 18, 2008 Status Member Last seen December 19, 2008 - Dec 19, 2008 at 06:44 AM
yizsteph Posts 2 Registration date Thursday December 18, 2008 Status Member Last seen December 19, 2008 - Dec 19, 2008 at 08:00 AM
Hello,

I am trying to write a macro for the below problem:

User can specific a row by clicking the any cells in the worksheet
The macro will then recognise the row and copy the first 20 cells of the row.
It then paste it to the same row but from second cells of that row.

Many Thanks
Yizsteph

2 responses

yizsteph Posts 2 Registration date Thursday December 18, 2008 Status Member Last seen December 19, 2008 6
Dec 19, 2008 at 08:00 AM
I think i have found my solution ..

With ActiveCell
Range(Cells(.Row, "F"), Cells(.Row, "X")).Select
Selection.Cut Destination:=ActiveCell.Offset(0, 1)
End With
8
pianomonster Posts 25 Registration date Monday August 25, 2008 Status Member Last seen May 16, 2009
Dec 19, 2008 at 07:05 AM
hi
can you be more explicit about your problem please??
0