Why UDF Array Functions are Faster

Over at FastExcel the answer was given why UDF arrays go faster to the question I had on why UDF array formulas are faster than regular formulas. I had forgotten about this post that he had written.

Here’s the answer that he gives. Check out his blog post to see more of the details of why this is.

You can break down the time taken by a VBA UDF into these components:

Thu Mar 29, 2012 | tags: excel array-functions

comments powered by Disqus