Home |
Search |
Today's Posts |
#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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink problem to cell in same workbook
You have replies at your other posts.
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink problem to cell in same workbook
You wasted my time.
NOT APPRECIATED!!!!!!!!!!!!!!!! -- Gary Brown "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink problem to cell in same workbook
Many apologies if you believe I wasted your time. I simply posted the
same question in more than one group in the hope I would get an answer. I do appreciate everybodies help. Thanks Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink problem to cell in same workbook | Excel Discussion (Misc queries) | |||
How do I copy a cell + it's formula from one workbook to another? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
Hyperlink a word within a cell | Excel Discussion (Misc queries) |