Thread: cut and pasting a row in another workbook on the next available l.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
bigwheel bigwheel is offline
external usenet poster
  
Posts: 222
Default cut and pasting a row in another workbook on the next available l.
Something like this will do the trick:-

ActiveCell.EntireRow.Select
Selection.Cut
Sheets("Sheet2").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste

"stressed" wrote:

I want to record a macro which cuts a row from a sheet and pastes the row
into another sheet without deleting any existing rows.
Reply With QuoteReply With Quote