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?

One way:

Wrap your code with

Application.Calculation = xlCalculationManual

<your code here>

Application.Calculation = xlCalculationAutomatic

In article <C35EDECA-5D39-4343-BF5C-(E-Mail Removed)>,
BZeyger <(E-Mail Removed)> wrote:

> 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?

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


"JE McGimpsey" wrote:

> One way:
>
> Wrap your code with
>
> Application.Calculation = xlCalculationManual
>
> <your code here>
>
> Application.Calculation = xlCalculationAutomatic
>
> In article <C35EDECA-5D39-4343-BF5C-(E-Mail Removed)>,
> BZeyger <(E-Mail Removed)> wrote:
>
> > 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?
>