Monthly Archives: October 2013

Parsing Functions from Excel Formulas using VBA: Is MID or a Byte array the best method?

Posted on October 27, 2013 by fastexcel

As part of extending the performance profiling abilities of FastExcel, I wanted to develop a Function Profiler Map. A key component of this is to extract the names of the functions embedded in Excel formulas. So I experimented with some … Continue reading →

Posted in Calculation, VBA | 2 Comments

UNIQUES and DISTINCTS: exploring lists with LISTDISTINCTS

Posted on October 14, 2013 by fastexcel

I just added some options to the SpeedTools LISTDISTINCTS functions that make them surprisingly powerful. You can now easily find the most frequently occurring item in a list, or find the item with the largest sum or average of a … Continue reading →

Posted in Calculation, UDF, XLL | Tagged , , | 3 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

Using ENVIRON to find the XLB and QAT files

Posted on October 1, 2013 by fastexcel

I am currently updating the FastExcel profiler to run with 64-bit Excel. This involves the rather tedious conversion of a large number of Windows API statements to use conditional compilation, VBA7 and WIN64. Whilst doing this I discovered the VBA … Continue reading →

Posted in VBA | 5 Comments