Thread: How do I copy several rows from one sheet to another?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saucer Man Saucer Man is offline
external usenet poster
  
Posts: 54
Default How do I copy several rows from one sheet to another?
I am currently doing...

ActQty.Entirerow.Copy Destination:=Sheets(1).Cells(.Rows.Count,
"A").End(xlUp).Offset(1,0)

....but the copied rows are copied to the bottom of the destination sheet.

I want the copied rows to start at row 15 of the destination sheet, not the
bottom. I also want just the data copied. I do not want the copied rows to
wipe out my cell formatting on the destination sheet.

Thanks!


--- Posted via news://freenews.netfront.net/ - Complaints to ---
Reply With QuoteReply With Quote