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.
- Setting Options
- from Mastering VBA for Microsoft Office 2007, 2nd Edition
- Publisher: Sybex
- Released: April 2008
Application.Calculation = xlCalculationManual, xlCalculationAutomatic
Share this highlighthttp://www.safaribooksonline.com/a/mastering-vba-for/4772936/