I have a large work sheet and need to link to several different ranges (52
ranges 1 for each week of the year) from the each of the same ranges. My
thought is a combo box labelled 'Go to Week no.' that i can list the 52
ranges e.g week1 week2 etc. and once selected it will create a hyperlink to
that specific range, i'd prefer the combo box rather than data validation as
you can increase the number of rows in the combo box (unlike the data
validation box) which means less scolling for selecting the link. I can
hopefully copy the combo box and paste in into several areas on the work
sheet?

Any suggestion would be appreciated.

The named ranges in the name box on the formula bar was one option, though i
already have around 70 links in there from another sheet so i'd rather not
increase this list!