dependent lists

[neveu]

Hello forum,

i've created several named ranges in sheet "Sheet1" starting with A1 and B1
(i have like 10 defined named ranges but for example i only copied these 2)

5A 5B
text1 txt1
text2 txt2
text3 txt3
text4 txt4
text5
text6

the first range include all the values below 5A (it's defined range name in BND5A)
similar for the column B range

what i want to do is to define a drop down list where when i have in the cell next to it the value 5A to show me the values in the BND5A ranges).

I've been struggling with this but can't figure it out how to solve it.

any inputs are very appreciated.

thank you
I've read that you can use the Indirect function to get

 

[Sandeep Warrier]

You can try using

dRangeAddress = Range(dRange).Address(External:=True)

The named range should be in the same workbook though.

 

[neveu]

That's perfect!
thank you very much