Search

Recent Posts
 Why Structured References are slow in Excel 2013 but fast in Excel 2016
 Excel Versions Screen Test (Updated): how fast is Screen Updating?
 Excel Memory Checking Tool: Using LAA to increase useable Excel memory
 2016 Microsoft MVP Summit, Part 2: Trump Wins
 2016 Microsoft MVP Summit, Part 1
 Writing Efficient VBA UDFs Part 15: Adding Intellisense to your UDFs
 Writing Efficient VBA UDFs Part 14: Handling whole columns using Implicit Intersection – Updated
 Excel: Evil and Hero Functions
 INDIRECT – Excel’s Most Evil Function
 Special Offer for Excel Summit South
Recent Comments
Joshua Kreuder on Why Structured References are… fastexcel on Why Structured References are… Joshua Kreuder on Why Structured References are… fastexcel on Why Structured References are… sam on Why Structured References are… Irina on Writing Efficient VBA UDFs Par… fastexcel on TEXT vs VALUE vs VALUE2… Michael L on TEXT vs VALUE vs VALUE2… Post Archive
 February 2017 (1)
 December 2016 (1)
 November 2016 (3)
 October 2016 (2)
 July 2016 (1)
 April 2016 (1)
 February 2016 (1)
 December 2015 (4)
 November 2015 (2)
 September 2015 (2)
 May 2015 (2)
 February 2015 (1)
 January 2015 (2)
 December 2014 (1)
 November 2014 (2)
 October 2014 (3)
 September 2014 (2)
 August 2014 (2)
 June 2014 (1)
 April 2014 (1)
 February 2014 (1)
 January 2014 (3)
 December 2013 (2)
 November 2013 (4)
 October 2013 (6)
 September 2013 (4)
 February 2013 (3)
 January 2013 (3)
 December 2012 (4)
 November 2012 (2)
 October 2012 (2)
 September 2012 (1)
 July 2012 (6)
 June 2012 (7)
 April 2012 (1)
 March 2012 (2)
 February 2012 (1)
 January 2012 (3)
 December 2011 (1)
 November 2011 (3)
 October 2011 (2)
 September 2011 (2)
 August 2011 (1)
 July 2011 (4)
 June 2011 (8)
 May 2011 (4)
Categories
Blogroll
RSS
Blog Stats
 639,563 hits
 Follow Excel and UDF Performance Stuff on WordPress.com
Tag Archives: array formula
Writing Efficient VBA UDFs Part 14: Handling whole columns using Implicit Intersection – Updated
Excel has an interesting and very efficient trick called Implicit Intersection which allows you to use large Named Ranges and whole column references efficiently. What is Implicit Intersection? When Excel expects to get a single cell reference but you give … Continue reading
Posted in arrays, Calculation, UDF, VBA, XLL
Tagged array formula, array function, Excel Formulas, Excel functions, UDF
9 Comments
Writing Efficient VBA UDFs (Part13): MaxMinFair Resource Allocation – an array UDF example
Last year we got to spend a great day at Microsoft Research in Cambridge (UK). one presentation was about storage strategies and featured (amongst other stuff) an interesting algorithm called MaxMinFair. The MaxMinFair algorithm You can read about it here … Continue reading
Calling XLAM/XLL/Automation UDFs from VBA: Evaluate, Run, or Reference?
I have this nagging feeling that I do not know the best way to call UDFs from VBA. So after a couple of days of research here is what I have found out so far. The Available Methods Application.ExecuteExcel4Macro This … Continue reading
Posted in Calculation, UDF, VBA, XLL
Tagged array formula, array function, calculation speed, UDF, XLL
4 Comments
Timing the Ins and Outs of User Defined Functions: MultiCell array formulas can be slow
I was looking at some multicell array formula UDFs with John and Rich and could not understand why they seemed so much slower than I expected. Each UDF (written as C++ XLLs) read data from around 200 cells using around … Continue reading
Posted in Calculation, UDF, Uncategorized, VBA, XLL
Tagged array formula, array function, calculation speed, Excel 2010 Calculation Bug, UDF, XLL
Leave a comment
Exploring Range.Calculate and Range.CalculateRowMajorOrder: fast but quirky formula calculation
The Range.Calculate methods are very useful additions to Excel’s other calculation methods (Application level Calculate, CalculateFull, CalculateFullRebuild and Worksheet.calculate: the missing one is Workbook.Calculate!). You can use the Range Calculate methods to: Force calculation of a block of formulas or … Continue reading