Macro Speed re: Evaluate

[JeffMelton]

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?

 

[Charles Williams]

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