Mike wrote on Sat, 19 Apr 2008 06:52:00 -0700:

MH The 2 lines below will do what you require but you need to
MH do something in between because when you delete the row you
MH lose the copied data.

MH ActiveCell.EntireRow.Copy
MH 'Do something with the copied data i.e paste it somewhere
MH else ActiveCell.EntireRow.Delete

MH Mike

MH "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.

The number of modifications that are available in VBA for
ActiveCell is amazing to me. Can you (or anyone else) suggest a
good book with a reasonably complete list of functions,
prefererably one that also teaches VBA for Excel?


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not