Category Archives: Formatting

Excel Versions Screen Test (Updated): how fast is Screen Updating?

Gurs has an interesting benchmark he has been running on various systems and Excel versions over the years. His results seem to show a massive performance decline in later Excel versions. Looking at his benchmark and its VBA code you … Continue reading

Posted in Calculation, Formatting, Uncategorized, VBA | 8 Comments

Excel Full Column References and Used Range: Good Idea or Bad Idea?

Some people love using full column references such as A:A, other people say they slow down your workbook to a crawl and lead to workbook and memory bloat. The attraction of using whole column references is that you don’t have … Continue reading

Posted in arrays, Calculation, Formatting, Memory | 5 Comments

Exploring Conditional Format Performance Part 3: What’s slow, whats buggy and whats faster!

This is the third in a series of Posts on Conditional Formats (see part 1 and Part2). This post looks at the effects  on the performance of Conditional Formats of: Application.Screenupdating Application.EnableConditionalFormatsCalculation Application.Calculation Whether the cells containing the conditional formats … Continue reading

Posted in Calculation, Formatting, UDF, VBA | Tagged , | 11 Comments

Exploring Conditional Format Performance Part 2: What’s slow, whats buggy and whats faster!

This is the second in a series of Posts on Conditional Formats (see part 1). This post looks at the effects (and the resulting bugs!)  on Conditional Formats of: Application.Screenupdating Application.EnableConditionalFormatsCalculation Application.Calculation Whether the cells containing the conditional formats are … Continue reading

Posted in Calculation, Formatting, UDF, VBA | Tagged , | Leave a comment

Exploring Conditional Format Performance Part 1: What’s slow, whats buggy and whats faster!

Patrick wanted to know if I had any information on Conditional Format calculation and performance, and I have  not looked at it for several years, so here goes! I have done a series of experiments, using Excel 2007, 2010 and … Continue reading

Posted in Calculation, Formatting, UDF, VBA | Tagged , | 1 Comment