I have a workbook with several VBA macros that write to cells, and it takes forever to run. I've monitiored it and I can write to cells faster than the macro can. The problem seems to be the summary sheet that has a hundred or so conditional formulas to summarize the data. When I remove the sheet, the macros run instantly. I do have screenupdating halted, but that doesn't seem to make any difference.
Is there a VBA command to stop all of the formulas from recalculating every time any cell gets written to? I know how to force calucation, but how do you prevent it?
I'd rather not have to write macros for every summary field.