INDIRECT will only work with static ranges.
In the prior post there's no code to worry about but the file would warrant being saved as .xlsm type given use of Evaluate in the _Workgroup named range.
As mentioned, if you have only a handful of named ranges you can use a CHOOSE based construct rather than the XLM Evaluate call
The formula for A10 onwards remain as outlined in the prior post.
The CHOOSE approach has added benefit of being non-volatile but has limited practicality pending number of named ranges in play.
Bookmarks