Where can you change automatic or manual calculation mode in ...

Use the following piece of VBA code: Application.Calculation = xlManual Turn Automatic Calculations Back On To turn back on automatic calculation with the setting xlAutomatic: Application.Calculation = xlAutomatic I recommend disabling Automatic calculations at the very beginning of your procedure and re-enabling Automatic Calculations at the end. ................
................