Hi

You can put that switch in the macro itself, so that it turns the calc to manual, then turns it back on again when it is finished.
Application.Calculation = xlCalculationManual

Application.Calculation = xlCalculationAutomatic

rylo