Copy and Paste cell

[Solved/Closed]
Report
Posts
2
Registration date
Thursday December 18, 2008
Status
Member
Last seen
December 19, 2008
-
Posts
2
Registration date
Thursday December 18, 2008
Status
Member
Last seen
December 19, 2008
-
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 replies

Posts
2
Registration date
Thursday December 18, 2008
Status
Member
Last seen
December 19, 2008
6
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
25
Registration date
Monday August 25, 2008
Status
Member
Last seen
May 16, 2009

hi
can you be more explicit about your problem please??