Why would macro slows down after each iteration and also why would it improves when I start another application? Performance related question

[korhan]

Hello all,
I have noticed a very interesting behavior when I was measure the timing on my macro?

I have used a pretty common method. Set the timer in the beginning of each iteration and then display how long each iteration takes.
In the beginning it was taking around 8 seconds for each loop and then started to increase to 11, 12, 15, 16, 17 ... so on but then when I started another application somehow time went back to 8 seconds. I have tested the same thing over and over again. Somehow, opening up another application resets this behavior. Anybody has noticed anything similar?

 

[Macropod]

That really depends on what your macro is doing. Macros that repeatedly write to a worksheet, especially to the same area, tend to slow down as they ever more data to Excel's undo buffer.