View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?