recall cell value in hyperlink
 

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.

recall cell value in hyperlink
 

no quotes around A1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bc84" wrote in message ...
| 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.
|

recall cell value in hyperlink
 

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. :)

"Niek Otten" wrote:

no quotes around A1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bc84" wrote in message ...
| 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.
|