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

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

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

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