June 2015
Beginner
288 pages
5h 27m
English
Chapter 12
In This Chapter
Halting sheet calculations
Disabling sheet screen updating
Turning off status bar updating
Telling Excel to ignore events
Hiding page breaks
Suspending pivot table updates
Steering clear of copy and paste
Using the With statement
Avoiding the Select method
Limiting trips to the worksheet
As your macros become increasingly robust and complex, you may find that they lose performance. When discussing macros, the word performance ...