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

Copy and Paste cell
Copy and paste fonts - Guide
If a cell has text then return value ✓ - Excel Forum
This message was deleted text copy and paste - Android Forum
If cell contains date then return value ✓ - Office Software Forum
How to paste photo in resume - Guide

2 responses

Answer 1 / 2

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

Answer 2 / 2

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??

Similar discussions

Can no longer paste text into insta

How can I make my name text invisible in Discord

help me to add particular cells

Highlight cell if another cell contains specific text

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!