Chapter 12

Ten Ways to Speed Up Your Macros

In This Chapter

arrow Halting sheet calculations

arrow Disabling sheet screen updating

arrow Turning off status bar updating

arrow Telling Excel to ignore events

arrow Hiding page breaks

arrow Suspending pivot table updates

arrow Steering clear of copy and paste

arrow Using the With statement

arrow Avoiding the Select method

arrow 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.