Some functions do vary when called through Application.WorksheetFunction.Function vs Application.Function, which other ones are I can't quite remember.

Remember that whilst using formulas on arrays is possible, it usually much slower than simply looping through - on small arrays this is unlikely to matter a great deal, but it can have an impact on larger ones. Though don't forget the premature optimisation!

As an aside, the method you discuss is quite nicely written up here by DonkeyOte: http://www.excelforum.com/tips-and-t...2d-arrays.html