Hi,
I have a workbook that contains large formulas in each cell of a certain range in a worksheet (AC16:SMF988). The formulas refer to other worksheets in the workbook, as well as to the worksheet that the formulas themselves are located in.
Excel will run out of resources quickly when I am trying to copy these formulas across even a small section of the aforementioned range when using Automatic calculation method. Excel will also run out of resources If I copy the formulas across in Manual calculation method first and then click Calculate sheet. What seems to work though, is that I copy the formulas across in Manual calculation mode and then calculate each formula one by one, by clicking inside the formula bar of the cell containing the formula and pressing enter. This will take an awful lot of time though, if I'm going to run through the range manually.
I therefore wonder if someone has a VBA code that could run through each cell in the range AC16:SMF988 and calculate the formulas one by one, proceeding to the next one only when calculation of the current formula has been completed, if I have first pasted them across the range in Manual calculation mode?
Best regards,
Marbleking
Bookmarks