Hyperlink Codes

[Varne]

Hi

Once when I used an earlier version of Excel I was able to record
hyperlinking a cell. I am sure. Now in one Excel 2003 version I am unable to
do it.

My problem is this:

Using a macro I use 'find' to reach a target (find) in an other page.
Therefore the activecell in the original page will not change.
I want to hyperlink it to the found (find) cell.

It is enough if someone gives the hyperlink codes only.

Thanks.

M Varnendra

 

[Varne]

Hi

Sorry. It works now.

Sheets("sheet2").Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"sheet1!a100"

However how can I convert "=sheet1!a2" into variable reference?

Could someone help please?

Thanks
M Varnendra

 

[Varne]

Got it.

Sheets("Introduction").Hyperlinks.Add Anchor:=Selection, Address:="",
SubAddress:= _
"'Introduction'!" & "" & ActiveCell.Address

M Varnendra