AutoCalculation Question

[dturgel]

I'm having a tough time speeding up a macro that runs through a very long sequence of steps. What's strange is when I switch excel to manual calculation, it flies through the macro in 4-5 seconds but when I switch the code to reflect this (i.e. put in xlCalculationManual in the first line of the code and xlCalculationAutomatic in the last line of the code) it is still really slow - does anyone know if it makes a difference where I put these commands in the code? Should I put them in multiple places within the code? Any ideas are greatly appreciated.

 

[Jeffrey Mahoney]

Hi dturgel

This should go at the very top: Application.Calculation = xlCalculationManual
This should go at the very bottom: Application.Calculation = xlCalculationAutomatic

If you are using nested subroutines, one of them may turn the calculation back to automatic before it comes back to the calling SUB. You'll need to look for that. I use them all the time and it works like you want.

Jeff

 

[dturgel]

Jeff,

Yes, I am using nested subroutines - I will turn them off in them and let you know how it goes - thanks so much for your advice!

Daniel