I've written a macro that uses Evaluate("=Sumproduct(--(..... quite a
bit. It seemed like it took quite a while to run so I made a quick
macro that puts the formula in a cell and then autofill it to the rest
of the large range I was using. Anyway, the latter method took about
half the time to calc.

Is this normal for a macro calculating a lot slower than the excel
sheet?