Hi All,
I have a large macro that copie over 300 ranges of cells from one worksheet to another worksheet in the same workbook, the whole thing take over 60 seconds to complete. I am looking for a way to speed up this process.
an example of one range copy is
I have been looking around and I came across this line that supposedly speeds up the copying by bypassing the clipboard
has anyone used this in the past? is it compatible with 2007?
I have a large macro that copie over 300 ranges of cells from one worksheet to another worksheet in the same workbook, the whole thing take over 60 seconds to complete. I am looking for a way to speed up this process.
an example of one range copy is
Code:
Sheets("scores").Select
Range("BK7:BQ7").Select
Selection.Copy
Sheets("scoresheets").Select
Range("C70").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
I have been looking around and I came across this line that supposedly speeds up the copying by bypassing the clipboard
Code:
worksheetname.Range("A1:A6").Value = worksheetname.Range("A1:A6").Value
has anyone used this in the past? is it compatible with 2007?