Solved: Stop excel from calculating

[jazzyt2u]

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

[Digita]

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

[jazzyt2u]

Thanks a bunch!!!!