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?

assuming you have calculation set to manual using autofill does NOT
calculate formulae as they are entered, so you are not comparing like for
like.

see http://www.decisionmodels.com/optspeedj.htm for some comments on
speeding up SUMPRODUCT/Array formulae
(Evaluate will handle array formulae).

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"JeffMelton" wrote in message
oups.com...
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?