General discussion
October 27, 2004 at 04:37 PM
jorge.aguilar

Macros running slow in EXcel

by jorge.aguilar . Updated 21 years, 9 months ago

I have a problem with a macro in Excel, running slow.

This macro runs in 10 seconds ( for each iteration it makes around 30 iteration in total) in one machine but in another with the same hardware characteristic takes 3 minutes in the same operation, I review the code and it is taking time in the line “Selection.Copy”:
This is a sample of the code with problems.
Sheets(“Lo format”).Select
Cells.Select
Selection.Copy
Windows(File2).Activate
Sheets(hoja).Select
Range(“A1”).Select

The information being copied has a big size but I do not understand why takes different time in one machine than in another, what configuration should i review?

Regards Jorge

This discussion is locked

All Comments