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

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

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