![]() For example, a cell with formula =HYPERLINK(“#Sheet2!C3”, “Link to C3”) will contain the text “Link to C3”, and function as a hyperlink to that cell in Sheet2. The solution is to enclose the name of the destination cell in quotes and preface it with a pound sign. Simply passing the name of a cell to the function causes it to form a bad link Excel will interpret it as a URL. Normally, the hyperlink function creates a link to a URL, much like the CreateHyperlink function. SolutionĮxcel has a function named hyperlink() that, with some special syntax, can create links to other cells in a spreadsheet. This article discusses a workaround using Excel’s HYPERLINK function. Your application requires cells to contain hyperlinks to other cells in the same spreadsheet, but the Cell.CreateHyperlink function only makes links to URLs on the internet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |