Problem using a dynamic named range as an INDIRECT source for a Data Validation list :(

Hello all

I've come across something when setting up some data validation lists in a model I'm building for work. In one section of the model I've added in dynamic drop-down lists, so if the user selects one option from a list in cell A1 for example the model then gives him a subsequent list of further options in A2, based on what was selected in A1. No problems there. But....whenever I try to set up the Source so that the INDIRECT function calls on a dynamic named range I get the error message: "The Source currently evaluates to an error. Do you want to continue?" I've tried testing this by changing the range from dynamic to static and it now works fine, so does this mean Excel cannot use dynamic named ranges in Data Validation?

Any help is always appreciated

Kenny

When you refer to a range reference using INDIRECT, it should be formed as text.

If you have 'real' dynamic ranges, then you don't need INDIRECT, just set the dynamic range as the source of your dropdown list directly.

Just a check...

dependent dropdown list, it needs the support of Indirect function

INDIRECT is the preferred way, but I'm pretty sure the above statement is falsifiable.