Category Archives: Uncategorized

The Amsterdam Excel Summit

A Unique Opportunity Dear Excel lovers, Is Excel the first and last application you use every day? Do you want to improve your Excel skills and get first-hand knowledge from the absolute best Excel experts in the world? Then this … Continue reading

Posted in Uncategorized | 2 Comments

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 85,000 times in 2013. If it were an exhibit at … Continue reading

Posted in Uncategorized | Leave a comment

Summit Winter 2013

On Saturday I got back from the winter 2013 MVP summit at the Microsoft campus in Redmond. The summit is a great chance to talk to the Microsoft Excel teams and to meet up with other Excel MVPs. I also … Continue reading

Posted in Uncategorized | 6 Comments

Pivot Table Sort is Too Clever

I created a pivot table from a list containing 3 character IDs, then used the Pivot Table field pulldown to sort it. The resulting sorted list looks like this: Looks like Pivot Table sort recognises 3 character abbreviations for The … Continue reading

Posted in Uncategorized | 6 Comments

Custom Excel Worksheet Templates in Departmental Solutions – Pros and Cons

Excel allows you to create and use custom workbook and worksheet templates (you can also change the default workbook and worksheet templates). This post explores the pros and cons of using custom Templates in the sort of general purpose departmental … Continue reading

Posted in Calculation, Uncategorized, VBA | 2 Comments

Catchup Post

The blog has been quiet for too long … That’s because I have been too busy with a large customer project and summer activities. This summer after 32 years we decided to sell our lovely Norfolk holiday cottage: and downsize … Continue reading

Posted in Sailing, Uncategorized | Leave a comment

Writing Efficient UDFs Part 12: Getting Used Range Fast using Application Events and a Cache

In the previous post I suggested that one good way to speed up retrieval of the Used Range last row would be to use a Cache and the AfterCalculate Application event. I have now tested this approach and it works … Continue reading

Posted in Calculation, UDF, Uncategorized, VBA | Leave a comment

From VBA to C Part 9 – the additional Types of UDF you can create in an XLL

In VBA you can create a UDF that returns any VBA datatype, but there are really only 2 kinds of UDFs: Volatile and Non-Volatile. In the C XLL UDF world there are several other types that you can create. Features … Continue reading

Posted in Uncategorized | Leave a comment

From VBA to C Part 5 – Some Pratfalls – the mistakes I keep making

I have been coding in VBA since Excel 5 (1993) so I keep trying to do VBA things in C, specially when I spend a few weeks doing VBA stuff and then switch back to C. Here are (just a … Continue reading

Posted in UDF, Uncategorized, VBA, XLL | 7 Comments

From VBA to C Part 4 – A small subset of simple C syntax

And just how fast can you say “A small subset of simple C syntax”? The benchmark¬† UDF In this post I am going to build a simple benchmark UDF. I have chosen the AverageTol UDF that was implemented as optimised … Continue reading

Posted in UDF, Uncategorized, VBA, XLL | 4 Comments