Hi Mike,

in my experience, copying formulas is quicker than populating each cell
with formula.

You can save some time if you set application.calculation to
manual/automatic and application.screenupdating to false/true. You can
also decrease number of dots in your code by using with .. end with
statements. If you use loops, be sure that any unnecessary code is not
inside the loop.

Regards,
Ivan