Solved: Stop excel from calculating

Hi,
Is there a way to keep Excel from calculating because it's taking a long time to run the macro because the file keeps calculating: (1 processor(s)) 0% and it takes forever for it to get to 100% at which the macro goes to the next bit of coding...

Thanks,
jazzyt2u

Hi jazzyt2u,

[VBA]Application.Calculation = xlManual[/VBA]

The above command turns calc mode from auto to manual. However, you should check the code to ensure that it does not have any boolean tests which rely on the calculation output before turning off the auto calc mode. At the end of the code, turn the auto calc back on by

[VBA]Application.Calculation = xlAutomatic[/VBA]

Regards


kp

Thanks a bunch!!!!