I’m trying to use a dynamic reference to named formulas. Each formula has a Name ending with a number ATEST1, ATEST2 etc. I am referring to the named formulas using the indirect function.However, when I do I get a #REF error.Formula:Please Login or Register to view this content.
Things I have tried;
Building a dynamic reference to a name returns valid results If the name is not a formula and just refers to a cell.
Building the dynamic reference to the name formula returns #REF.
Referring directly to the named formula returns a valid result.
I have simplified and duplicated this problem in the attached workbook.
If there is a way to pull this off please enlighten me.
Thanks
Robert
Bookmarks