Why is my macro slow only some of the time?

**jagman1990** · 12-20-2010, 11:14 AM

I have a very simple copy and paste macro that reorganizes the cells into the correct positions. I have 3 different excel 2003 workbooks that I am using this on. Same code for each. On one of the workbooks, it had 1200 rows. That took 3min to finish. Another workbook with 7000 rows took 6min. now the last workbook with 22000 rows is gonna take like 6 hours. Its incredibly slower. But this same probably also happened with the first 2 workbooks the first few times I ran the macro on them. I can't figure out why sometimes they are working...any ideas?

**romperstomper** · 12-20-2010, 11:16 AM

Hard to say for sure without the code, but are you turning off calculation, screenupdating and events at the start of your code and then turning them back on again afterwards?

**BigDat6CC** · 12-20-2010, 11:23 AM

Your choice of computer and the other programmes you may be running on it at the same time as Excel will affect the processing time.

If you have automatic back-ups switched on and Windows is going about its business, then that is going to be a contributing factor. Or an anti-virus sweep. Or an automatic back-up to the cloud.

Please excuse me if I am suggesting the obvious.

**jagman1990** · 12-20-2010, 11:28 AM

yea romperstomper I have all of that in the code and it doesnt help at all. And on the computer I am running the macro, excel is the only program I have running. Now we are on a business network here so I am not sure what they have running in the background on these computers. It is just weird that for 2 of the 3 workbooks it runs extremely fast and the third it doesnt. yet its the exact same code and setup just more rows...

**romperstomper** · 12-20-2010, 11:46 AM

I find it extremely unlikely that that does not help at all! Have you tried it without those in there?
Anyway, as I said, I can't really comment without seeing the code.