I am helping another member with some code that he has. He needs to create a formula that references another sheet. The only problem is that he creates the sheet after the point where the formulas are to be entered.

This means that the formulas come up with the #Ref! error. The formula is correct, it's just that at the time of its creation, it doesn't point to anything. If I select a cell with this error message in it manually and then go to the formula box and press enter, the formula evaluates properly.

However, this means selecting each cell individually, going to the formula bar and pressing enter.

Calculate does not work. All the articles I've seen say this is the way to "force" the calculation.

Looping through the cells and selecting them isn't good enough. You MUST go to the formula bar and re-enter the formula.

I was wondering if there is a solution to this issue.

The correct thing to do is create the sheets before putting in the formulas. I'm not willing to do a major rewrite of the code.