| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to evaluate a cell and replace one part of the formula | Excel Programming | |||
| Challenging Macro to perform evaluate function on each cell | Excel Programming | |||
| Need a macro to evaluate and sift-through data | Excel Programming | |||
| tracking a macro like the evaluate formula tool | Excel Programming | |||
| Speed-up macro | Excel Programming | |||
Threaded Mode
