Adding more parameters to decide hyperlink address

[Ratiocination]

Hi, i've tried adding to code to make a single hyperlink have multiple, or in this case more than 2 addresses. If you open the attached sheet and look in the vba editor you'll see how the code looks at the moment. My question is how do i add to it so that the hyperlink will have more than 2 possible pathways.

Many thanks in advance.

Please Login or Register  to view this content.

[Alf]

Modified your code a bit, you could perhaps try something like this.

Please Login or Register  to view this content.

HTH

Alf