Category Archives: Formatting

Strategies for getting the last row in Excel with VBA

Posted on September 1, 2017 by fastexcel

Using VBA to get the last row in Excel can be a surprisingly complex task. This post will explore some of the different strategies you can use. The first thing to do is to decide what you mean by “The … Continue reading →

Posted in Excel, Formatting, VBA | Tagged , | 10 Comments

Excel Range.Value(ValueType): What is this parameter?

Posted on March 13, 2017 by fastexcel

Whilst visiting Microsoft Research in Cambridge I was chatting to fellow MVP Roger Govier. He mentioned that he was using this strange parameter to the Range.Value (ValueType) method, which I had been meaning to look at for a long time … Continue reading →

Posted in Formatting, VBA | Tagged , | 10 Comments

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

Posted on December 14, 2016 by fastexcel

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 | 9 Comments

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

Posted on December 12, 2015 by fastexcel

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!

Posted on October 11, 2013 by fastexcel

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!

Posted on October 10, 2013 by fastexcel

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!

Posted on October 9, 2013 by fastexcel

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 , | 4 Comments