Copy current row to clipboard and delete row
Hi,
The 2 lines below will do what you require but you need to do something in
between because when you delete the row you lose the copied data.
ActiveCell.EntireRow.Copy
'Do something with the copied data i.e paste it somewhere else
ActiveCell.EntireRow.Delete
Mike
"GKW in GA" wrote:
I would like to create a macro that will copy the row of the cell that the
cursor is currently in and delete that row.
How to do?
|