Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346