If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink problem to cell in same workbook
I have a hyperlink created by a VB program that should link to a cell
on a different worksheet within the same book. The hyperlink code currently is as follows: =HYPERLINK(ADDRESS(4,2,1,FALSE,"MultipleAliases"), "MULTIPLE DP ALIASES") MultipleAliases is a separate worksheet and I want the link to jump to row 4 cell 2 on this sheet. I realise that normally you need a spreadsheet identifier as part of the worksheet definition, thus the "MultipleAliases" would be "[FILE1.XLS]MultipleAliases" if this was saved as FILE1.XLS. If I do save this file with the altered hyperlink it works. The problem is when the spreadsheet is first created, it is not yet saved (I guess it is held in the temporary folder). Thus the hyperlink does not work, even without [FILE1.XLS] in the text. While this is still a temporary unsaved file, how do I define the sheet identifier part of my ADDRESS statement so that it finds the MultipleAliases sheet in the current document? You can easily try this out by opening an excel spreadsheet, rename Sheet2 to MultipleAliases and trying variations of the hyperlink text in a Sheet1 cell. Please note, I cannot define the cell to jump to in terms of a named cell and can only use co-ordinates to identify it (due to this text being created by VB), hence the use of ADDRESS to locate the cell. Cheers Mark |
#2
|
|||
|
|||
Hyperlink problem to cell in same workbook
You have a couple of responses to your post in .excel.
stainless wrote: I have a hyperlink created by a VB program that should link to a cell on a different worksheet within the same book. The hyperlink code currently is as follows: =HYPERLINK(ADDRESS(4,2,1,FALSE,"MultipleAliases"), "MULTIPLE DP ALIASES") MultipleAliases is a separate worksheet and I want the link to jump to row 4 cell 2 on this sheet. I realise that normally you need a spreadsheet identifier as part of the worksheet definition, thus the "MultipleAliases" would be "[FILE1.XLS]MultipleAliases" if this was saved as FILE1.XLS. If I do save this file with the altered hyperlink it works. The problem is when the spreadsheet is first created, it is not yet saved (I guess it is held in the temporary folder). Thus the hyperlink does not work, even without [FILE1.XLS] in the text. While this is still a temporary unsaved file, how do I define the sheet identifier part of my ADDRESS statement so that it finds the MultipleAliases sheet in the current document? You can easily try this out by opening an excel spreadsheet, rename Sheet2 to MultipleAliases and trying variations of the hyperlink text in a Sheet1 cell. Please note, I cannot define the cell to jump to in terms of a named cell and can only use co-ordinates to identify it (due to this text being created by VB), hence the use of ADDRESS to locate the cell. Cheers Mark -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlink problem to cell in same workbook | stainless | Worksheet Functions | 4 | November 16th, 2005 08:10 AM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Problem: VLOOKUP for HYPERLINK address (in UNC format) | James Cox | Worksheet Functions | 1 | January 7th, 2004 02:20 PM |
Cannot link workbooks by selecting 2nd workbook cell | pkley | Worksheet Functions | 1 | December 28th, 2003 05:04 AM |
lookup for a range around a cell in another workbook | Valeria | Worksheet Functions | 2 | November 13th, 2003 12:15 PM |