Macro running slow first time only

[djamieson18]

Hi Folks,

I am using Excel Mac 2011 and have a rather large macro that takes information from a very large global worksheet (10,000 rows) and creates approx 100 new worksheets. It's mostly nested for loops, nothing too complex.

The overall performance of the Macro is fine, taking around 10 minutes, however when I open Excel and launch the macro, it takes about 3 times longer than that to run. If I run it again in the same excel session, it is back to taking only 10 minutes and is fine any further times I run it after that.

My code is far too large to post but can anyone suggest any avenues that may be worth looking into to remove this problem?

Thanks,

Dave

 

[jproffer]

I assume you have screenupdating and calculation off/manual while the code is running?

Short of that, we would have to see it. There have been some pretty long codes posted here...try us