Create Hyperlink in Current Cell
I have a list of thousands of web addresses in a column. Far to many to "add
hyperlink" to each manually. I would like to step through these automatically and used the current value of the cell as the Hyperlink address and Text to Display. Any suggestions would be appreciated. Thanks -- Andrew Mitchell |
Create Hyperlink in Current Cell
It's been a long, long time since I've used a VB module / macro script and
I'm no longer sure of the proper referencing for the cells etc. -- Andrew Mitchell "Wigi" wrote: Why don't you use the HYPERLINK function in Excel? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "AGMNS" wrote: I have a list of thousands of web addresses in a column. Far to many to "add hyperlink" to each manually. I would like to step through these automatically and used the current value of the cell as the Hyperlink address and Text to Display. Any suggestions would be appreciated. Thanks -- Andrew Mitchell |
Create Hyperlink in Current Cell
UPDATE:
Wigi, I've tried the Hyperlink Function in Excel. When the original cell contains www.xyz.com and you use the hyperlink function in say an adjacent cell it creates the hyperlink, however the hyperlink does not contain http:// at the beginning and always says "Cannot open File" when clicked. I can add http:// to the beginning of each web address and then use the Hyperlink function; however I only want to show www.xyz.com in the cell. What I was really looking for was VB to take the value of the cell and assign that value as the hyperlink Address and Text. From what I've seen in some of the posts I should be able to use cell.value as the Address and Text; however I get an error each time. So if you could help me with vb to assign the current cell value to the hyperlink address and text I can do the rest. Thanks, Andrew -- Andrew Mitchell -- Andrew Mitchell "AGMNS" wrote: It's been a long, long time since I've used a VB module / macro script and I'm no longer sure of the proper referencing for the cells etc. -- Andrew Mitchell "Wigi" wrote: Why don't you use the HYPERLINK function in Excel? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "AGMNS" wrote: I have a list of thousands of web addresses in a column. Far to many to "add hyperlink" to each manually. I would like to step through these automatically and used the current value of the cell as the Hyperlink address and Text to Display. Any suggestions would be appreciated. Thanks -- Andrew Mitchell |
Create Hyperlink in Current Cell
If A1 contains www.xyz.com, try:
=hyperlink("http://"&a1,a1) AGMNS wrote: UPDATE: Wigi, I've tried the Hyperlink Function in Excel. When the original cell contains www.xyz.com and you use the hyperlink function in say an adjacent cell it creates the hyperlink, however the hyperlink does not contain http:// at the beginning and always says "Cannot open File" when clicked. I can add http:// to the beginning of each web address and then use the Hyperlink function; however I only want to show www.xyz.com in the cell. What I was really looking for was VB to take the value of the cell and assign that value as the hyperlink Address and Text. From what I've seen in some of the posts I should be able to use cell.value as the Address and Text; however I get an error each time. So if you could help me with vb to assign the current cell value to the hyperlink address and text I can do the rest. Thanks, Andrew -- Andrew Mitchell -- Andrew Mitchell "AGMNS" wrote: It's been a long, long time since I've used a VB module / macro script and I'm no longer sure of the proper referencing for the cells etc. -- Andrew Mitchell "Wigi" wrote: Why don't you use the HYPERLINK function in Excel? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "AGMNS" wrote: I have a list of thousands of web addresses in a column. Far to many to "add hyperlink" to each manually. I would like to step through these automatically and used the current value of the cell as the Hyperlink address and Text to Display. Any suggestions would be appreciated. Thanks -- Andrew Mitchell -- Dave Peterson |
All times are GMT +1. The time now is 04:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com