Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2008

Tip: Looking for answers? Try searching our database.

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.
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.
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.