Quote Originally Posted by Norie
I might be wrong but I would think that using Excel's inbuilt functionality eg worksheet functions would be faster/better than trying to use code, or as some say reinvent the wheel.
There are many circumstances where you would be wrong.

Array formulae are expensive, and many of them are slow, so VBA can be a better option.