Need Fast VBA Range Copy

[deluxes]

I am using EXCEL X on a G4 800mhz with OS 10.2.8. I am using a macro
that copies ranges from one sheet to another using the code below:


'Worksheets("input").Range("$A$" & StartRow & ":$A$" & LastRow).Copy _
Destination:=Worksheets("output").Range("$A$" & StartRow &
":$A$" & LastRow) ' Chem Number

Each range contains 2500 entries, I do 5 of them and it takes about 69
seconds. Does anyone know a faster way to perform a copy? I would
appreciate any help you can give me.

 

[J Laroche]

deluxes wrote on 2005/03/04 14:19:

I am using EXCEL X on a G4 800mhz with OS 10.2.8. I am using a macro
that copies ranges from one sheet to another using the code below:


'Worksheets("input").Range("$A$" & StartRow & ":$A$" & LastRow).Copy _
Destination:=Worksheets("output").Range("$A$" & StartRow &
":$A$" & LastRow) ' Chem Number

Each range contains 2500 entries, I do 5 of them and it takes about 69
seconds. Does anyone know a faster way to perform a copy? I would
appreciate any help you can give me.

I tried your code to copy ranges of 30000 rows (not 2500 like you), and it
took less than a second each (on a G4 733). So I think the problem is not
with that copy process, but with other activities in your workbook (like
conditional formatting, calculations, pivot table, links to other workbooks,
etc.).

JL
Mac OS X 10.3.8, Office v.X 10.1.6