Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

In Excel 2003 use text in a referenced cell as Link_location

May 5, 2010 6:40AM PDT

Using Excel 2003, I want to use the text in reference cell as the Link_location for a HYPERLINK. Many sites say you can do that, but none say how to do it. I have tried using the address of the referenced cell as the Link_location, but that does not work. Any ideas?

Discussion is locked

- Collapse -
Could you explain a little bit more?
May 5, 2010 7:28AM PDT

Like: A1 contains a hyperlink to forums.cnet.com
In B1 I want ...
Etc.

Kees

- Collapse -
RE: using a referenced address-text as a Link_location.
May 5, 2010 9:28AM PDT

I'm trying to use this for my stock-tracking Excel file. I previously used the actual (YahooFinance) Http-url for each stock as the HYPERLINK, but, for some reason these would get lost or messed up when I updated my stock-list. Now I am using a separate column for the urls and wish to use these urls as the hyperlinks for the actual stock names in a separate column. I have been trying to use the address for the urls (C6,C7, etc.) as the Link_location part of the hyperlink, and it seems that I had this working sometime back, but it no longer works when I click on the stock-names.
I have seen articles on the web that state that what I am trying to do is possible, but none of these articles say how to do it.