PDA

View Full Version : Most efficient way to copy and paste



austenr
01-16-2006, 12:21 PM
As with everything there are many ways to complete a task. If you have to copy many rows from a group of worksheets to another what is the quickest way with consideration to processing time? I am cycling through a workbook with 25 sheets and transferring certain rows to a master sheet. Thanks

Killian
01-16-2006, 01:22 PM
For copying ranges, I've found the easiest way is the standard Copy methodThisWorkbook.Sheets(1).Rows(1).Copy _
Destination:=Workbooks("DestWB").Worksheets(2).Range("A1") rather than setting specific range variables for source and destination and making one=the other.
As a native function, I would imagine it would be faster but my theory is untested as yet... at least by me