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.