recall cell value in hyperlink

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bc84 - 06 Feb 2008 21:52 GMT

Thanks for taking the time to read and hopefully help me come up with a
solution...

Cell A1 = 1234

cell A2 =hyperlink("http://www.website.com/" & "A1" & ".aspx","name to
appear in speadsheet cell A2") where A1 needs to be "1234" the value of cell
A1

so the hyperlink I am wanting is "http://www.website.com/1234.aspx"

For some reason I can not get the "1234" to get in there by clicking on A1
while imputing the code.

Reply to this Message

Niek Otten - 06 Feb 2008 21:59 GMT

no quotes around A1

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Thanks for taking the time to read and hopefully help me come up with a
| solution...
[quoted text clipped - 9 lines]
| For some reason I can not get the "1234" to get in there by clicking on A1
| while imputing the code.

Reply to this Message

bc84 - 06 Feb 2008 22:30 GMT

Thank you Niek. 2 hours of trying different things and bam. I could have
sworn I have tried that but it is working. thank you

ps. The link in the automated response did not work until five minutes
after I got it. Very Frustrating. If you could pass that along to the right
department. :)

> no quotes around A1
>
[quoted text clipped - 11 lines]
> | For some reason I can not get the "1234" to get in there by clicking on A1
> | while imputing the code.

Reply to this Message