How do you stop calculating when running a macro?

[Guest]

I have a large report in which I perform numorious sorts. The report takes a
long time to create because after every sort, it goes through the
calculations. Is there a way to run the report without it calculating until
the very end?

 

[JE McGimpsey]

One way:

Wrap your code with

Application.Calculation = xlCalculationManual

<your code here>

Application.Calculation = xlCalculationAutomatic

 

[Guest]

Also, switch application.screenupdating=false at the beginning and switch it
back to true at the end - that will speed things up as well.