Macro Speed Evaluate
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? |
Macro Speed Evaluate
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? |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com