| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clipboard copy & paste | Excel Discussion (Misc queries) | |||
| Copy chart to clipboard - VBA | Charts and Charting in Excel | |||
| Clear Clipboard after Copy | Excel Discussion (Misc queries) | |||
| copy to the clipboard and into another workbook | Excel Discussion (Misc queries) | |||
| Can't copy without clipboard open | Excel Discussion (Misc queries) | |||
Threaded Mode
