dropdown menu of hyperlinks

[Sam K]

Hi All,

Is it possible to set up a drop down list of hyperlinks
that link to ranges in the same sheet. I have a large and
complex sheet.

Thanks in advance,
Sam

 

[Andy Brown]

Hi Sam,

Is it possible ...

I expect so ; but you could try another approach.

Define a name for each range, then use the Name Box to navigate. For how to
name ranges, see XL Help or
http://www.contextures.com/xlNames01.html

Rgds,
Andy