Hyperlink Function
I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2.
The value of Sheet1!A3 is Sheet2. I'm entering this formula, and no error value is returned, but it just doesn't go there. Here is the formula: =HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3) Any ideas? |
Hyperlink Function
In Sheet1,
I got this rendition to work ok: =HYPERLINK("#"&CELL("address",INDIRECT("'"&A3&"'!A 1")),A3) where in A3: Sheet2 -- Max Singapore http://savefile.com/projects/236895 Downloads:15,900 Files:354 Subscribers:53 xdemechanik --- "Hershey" wrote: I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2. The value of Sheet1!A3 is Sheet2. I'm entering this formula, and no error value is returned, but it just doesn't go there. Here is the formula: =HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3) Any ideas? |
Hyperlink Function
Thanks, Max
I learned to make use of 'address' info type I learned to enclose sheet names within apostrophes I noticed that the number sign has an effect on formatting, but I don't understand why The hyperlinked text is not underlined or blue, and is an isle of Veranda in a sea fo Arial. How? "Max" wrote: In Sheet1, I got this rendition to work ok: =HYPERLINK("#"&CELL("address",INDIRECT("'"&A3&"'!A 1")),A3) where in A3: Sheet2 -- Max Singapore http://savefile.com/projects/236895 Downloads:15,900 Files:354 Subscribers:53 xdemechanik --- "Hershey" wrote: I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2. The value of Sheet1!A3 is Sheet2. I'm entering this formula, and no error value is returned, but it just doesn't go there. Here is the formula: =HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3) Any ideas? |
Hyperlink Function
The hyperlinked text is not underlined or blue, and is an isle of Veranda
in a sea fo Arial. I'm not sure what's that, but think you can just format the formula cell in the normal way to taste. The "#" in the formula has nothing to do with formatting. -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "Hershey" wrote in message ... Thanks, Max I learned to make use of 'address' info type I learned to enclose sheet names within apostrophes I noticed that the number sign has an effect on formatting, but I don't understand why The hyperlinked text is not underlined or blue, and is an isle of Veranda in a sea fo Arial. How? |
Hyperlink Function
So what function does it serve? Why have you inserted the # ?
"Max" wrote: The hyperlinked text is not underlined or blue, and is an isle of Veranda in a sea fo Arial. I'm not sure what's that, but think you can just format the formula cell in the normal way to taste. The "#" in the formula has nothing to do with formatting. -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "Hershey" wrote in message ... Thanks, Max I learned to make use of 'address' info type I learned to enclose sheet names within apostrophes I noticed that the number sign has an effect on formatting, but I don't understand why The hyperlinked text is not underlined or blue, and is an isle of Veranda in a sea fo Arial. How? |
Hyperlink Function
So what function does it serve? Why have you inserted the # ?
See David McRitchie's page: http://www.mvps.org/dmcritchie/excel....htm#hyperlink " .. you can use the pound sign (#). By including the "#" the pathname can be left off, these work: in Excel 2000, and as I understand from Excel 97 and up .. " -- Max Singapore http://savefile.com/projects/236895 Downloads:15,900 Files:354 Subscribers:53 xdemechanik --- |
Hyperlink Function
That # is the subaddress indicator for the link.
This link: http://contextures.com/xlFunctions02.html will take you to the top of one of Debra Dalgleish's pages. This link: http://contextures.com/xlFunctions02.html#Trouble will take you to the section(?) named Trouble on that page. You may want to change the hyperlink style so that it's the way you want. In xl2003: format|Style Use the dropdown to choose Hyperlink Click Modify and make it what you want. Styles live in workbooks. So this change won't have any effect on any other workbook. Hershey wrote: Thanks, Max I learned to make use of 'address' info type I learned to enclose sheet names within apostrophes I noticed that the number sign has an effect on formatting, but I don't understand why The hyperlinked text is not underlined or blue, and is an isle of Veranda in a sea fo Arial. How? "Max" wrote: In Sheet1, I got this rendition to work ok: =HYPERLINK("#"&CELL("address",INDIRECT("'"&A3&"'!A 1")),A3) where in A3: Sheet2 -- Max Singapore http://savefile.com/projects/236895 Downloads:15,900 Files:354 Subscribers:53 xdemechanik --- "Hershey" wrote: I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2. The value of Sheet1!A3 is Sheet2. I'm entering this formula, and no error value is returned, but it just doesn't go there. Here is the formula: =HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3) Any ideas? -- Dave Peterson |
Hyperlink Function
Dave, thanks for chipping in with your explanations
Btw, would you happen to know what the OP meant by: .. an isle of Veranda in a sea fo Arial. -- Max Singapore http://savefile.com/projects/236895 Downloads: 16,000, Files: 354, Subscribers: 53 xdemechanik --- |
Hyperlink Function
Max
I didn't see the original post but maybe "An Isle of Verdana in a Sea of Arial" Referring to Font Types Gord On Fri, 18 Jul 2008 10:15:08 +0800, "Max" wrote: Dave, thanks for chipping in with your explanations Btw, would you happen to know what the OP meant by: .. an isle of Veranda in a sea fo Arial. |
Hyperlink Function
I think that's it, too.
An island of calm in a sea of hurricanes! (Ok, that ain't good.) Gord Dibben wrote: Max I didn't see the original post but maybe "An Isle of Verdana in a Sea of Arial" Referring to Font Types Gord On Fri, 18 Jul 2008 10:15:08 +0800, "Max" wrote: Dave, thanks for chipping in with your explanations Btw, would you happen to know what the OP meant by: .. an isle of Veranda in a sea fo Arial. -- Dave Peterson |
Hyperlink Function
Aha, thanks, Gord & Dave
It does sound like poetic font Max "Dave Peterson" wrote in message ... I think that's it, too. An island of calm in a sea of hurricanes! (Ok, that ain't good.) Gord Dibben wrote: Max I didn't see the original post but maybe "An Isle of Verdana in a Sea of Arial" Referring to Font Types Gord On Fri, 18 Jul 2008 10:15:08 +0800, "Max" wrote: Dave, thanks for chipping in with your explanations Btw, would you happen to know what the OP meant by: .. an isle of Veranda in a sea fo Arial. -- Dave Peterson |
All times are GMT +1. The time now is 06:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com