Chapter 12
Ten Ways to Speed Up Your Macros
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 ...
Get Excel Macros For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
