hyperlinks
Hi all,
Sorry that I am somewhat impatient. August 2 11.41 my time zone, I posted the request for help you see below. I don't know what to do with the "name section" ( TextToDisplay:="") of the instruction ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= "", TextToDisplay:="" because the text to display is the text (name) that already is in each cell that should become a hyperlink. TIA Jack ------------------------------------------------------------------------------------------------------ Hi all, Im my workbook in sheet 1 I have 100 names in A2:A101. I want to make each name a hyperlink that leads to the cell with the corresponding rownumber in column BB of sheet 2. So clicking the name/hyperlink in A8 of sheet 1 leads to BB8 in sheet 2. Etc. I can't figure out the code. Your assistance will be appreciated. Jack Sons The Netherlands |
hyperlinks
simplest is to just delete the texttodisplay section , it will then use the
existing display "Jack Sons" wrote: Hi all, Sorry that I am somewhat impatient. August 2 11.41 my time zone, I posted the request for help you see below. I don't know what to do with the "name section" ( TextToDisplay:="") of the instruction ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= "", TextToDisplay:="" because the text to display is the text (name) that already is in each cell that should become a hyperlink. TIA Jack ------------------------------------------------------------------------------------------------------ Hi all, Im my workbook in sheet 1 I have 100 names in A2:A101. I want to make each name a hyperlink that leads to the cell with the corresponding rownumber in column BB of sheet 2. So clicking the name/hyperlink in A8 of sheet 1 leads to BB8 in sheet 2. Etc. I can't figure out the code. Your assistance will be appreciated. Jack Sons The Netherlands |
hyperlinks
bj,
Thanks a lot, briljant. By the way. I think this is not documented in help, or is it? Jack. "bj" schreef in bericht ... simplest is to just delete the texttodisplay section , it will then use the existing display "Jack Sons" wrote: Hi all, Sorry that I am somewhat impatient. August 2 11.41 my time zone, I posted the request for help you see below. I don't know what to do with the "name section" ( TextToDisplay:="") of the instruction ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= "", TextToDisplay:="" because the text to display is the text (name) that already is in each cell that should become a hyperlink. TIA Jack ------------------------------------------------------------------------------------------------------ Hi all, Im my workbook in sheet 1 I have 100 names in A2:A101. I want to make each name a hyperlink that leads to the cell with the corresponding rownumber in column BB of sheet 2. So clicking the name/hyperlink in A8 of sheet 1 leads to BB8 in sheet 2. Etc. I can't figure out the code. Your assistance will be appreciated. Jack Sons The Netherlands |
All times are GMT +1. The time now is 11:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com