[SOLVED]Integrate (Indirect(address))

Well, it works here. (attached)

You can try recording your own version.

1. Create the error situation so #REF is on your sheet
2. Put the new Fcst template sheet in place.
3. Save your test sheet
3. Click on Record a new macro and call it FixRef
4. Now press Ctrl-H to open the Search/Replace window
5. Search for #REF
6. Replace with Fcst template (case sensitive, spell it right)
7. Click on Replace All, your formulas should be repaired now
8. Click the Stop Recording button
9. Go to your macros and Edit the new FixRef macro
10. Copy the entire macro here for us to see.
11. Close the test sheet without saving
12. Reopen the test sheet
13. Go to macros and paste this code you've copied into a new macro manually
14. Run the new macro again and see if it runs cleanly like it did the first time