O'Reilly logo
  • You Wang thinks this is interesting:

In complex worksheets that perform many calculations, you may need to turn off automatic calculation so that a procedure can enter data quickly without the calculations taking place.

From

Cover of Mastering VBA for Microsoft Office 2007, 2nd Edition

Note

Application.Calculation = xlCalculationManual, xlCalculationAutomatic