Indirect dynamic named ranges

[jasonb75]

Has anyone noticed any problems referencing dynamic named ranges with the INDIRECT function recently?

Dynamic ranges referenced directly work fine.
Named ranges with a fixed range work fine with INDIRECT
Dynamic named ranges referenced using INDIRECT return a #REF error. Not trying to refer to a closed workbook, doing all in same sheet for testing and it still fails.

The problem has occurred whilst helping another member set up dependent validation lists in excel 2016, methods that I've used in the past are no longer working.

Maybe something changed when dynamic arrays were introduced and I've only just noticed it?

 

[Fluff]

I was under the impression that you have never been able to use indirect with a dynamic name range, as the name is a formula rather than a string.

 

[jasonb75]

Possibly Mandela effect then, Fluff? I'm 100% convinced that I've done it previously, time to start digging around in some of my old stuff.