Create Hyperlink in Current Cell

[AGMNS]

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

 

[Wigi]

Why don't you use the HYPERLINK function in Excel?

 

[AGMNS]

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.

 

[AGMNS]

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

 

[Dave Peterson]

If A1 contains www.xyz.com, try:

=hyperlink("http://"&a1,a1)