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