Sorry, I didn't notice you were qualifying with .UsedRange

Evaluate is a very handy tool for avoiding Iteration, insertion of Formulae etc but pending complexity of the calculation to be performed it can become a little cumbersome to code.