Hyperlink to multiple cells

[hpatel517]

Hello all!

I am having an issue hyperlinking a cell to other cells in a different worksheet.

I can click on something have it go to Cells A1:A10 but I want the link to select cells A1 AND A10 only, not all encompassing.

Any thoughts?

Thank you!

[XOR LX]

Hi.

Not sure if you can also do it without recourse to a Defined Name, but you certainly can with.

If you go to Name Manager and define:

Name: Range1 (Or whatever you want to call it.)
Refers to: =Sheet2!$A$1,Sheet2!$A$10 (Change the sheet name as appropriate.)

Open the Edit Hyperlink dialog box and make sure you choose Place in This Document and then select the Defined Name.

Regards