Drop Down Menu & Named Range

[Toonloon]

Hi All,

I have a spreadsheet with approx 100 named ranges.

What i'm trying to do is to have a drop down menu with a list of these named ranges.

Once selected, the spreadsheet goes to the named range chosen.

Does anyone know if this can this be done ?

Thanks a million

 

[Toonloon]

Posted in error