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
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
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
Related:
- Copy and Paste cell
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- Copy and paste fonts - Guide
- Copy paste e with accent - Guide
- Excel Macro/Code help: Creating sheet for each name in column of another sheet ✓ - Excel Forum
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
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
With ActiveCell
Range(Cells(.Row, "F"), Cells(.Row, "X")).Select
Selection.Cut Destination:=ActiveCell.Offset(0, 1)
End With
pianomonster
Posts
25
Registration date
Monday August 25, 2008
Status
Member
Last seen
May 16, 2009
Dec 19, 2008 at 07:05 AM
Dec 19, 2008 at 07:05 AM
hi
can you be more explicit about your problem please??
can you be more explicit about your problem please??
