To create a Hyperlink object, call Cell.CreateHyperlink or Area.CreateHyperlink. To get an existing Hyperlink , use Worksheet.Hyperlinks. A Hyperlink only represents a URL to an external resource such as a web site. To create a link to another location in the workbook, you will need to use Excel's Hyperlink formula. You will need to surround the destination cell in quotes and preface it with a pound sign. For example, a cell with formula =HYPERLINK("#DestinationWorksheet!B3", "Link to B3") will contain the text "Link to B3", and if you click on that text it will bring you to cell B3 on the worksheet named DestinationWorksheet. |