I have a worksheet that has internet addresses to websites.
Since I pasted these into excel, the text is not an active hyperlink.
I need some VB to activate either the whole worksheet or a range to make the links active (hyperlinks).
I've tried all sorts of macros to accomplish this but can't seem to get it.
ie.
If I click into the cell, (as if I were going to edit), and then click out, the text (
) becomes a hyperlink to MSN.
How can I accomplish this over a large scale.
tav
Since I pasted these into excel, the text is not an active hyperlink.
I need some VB to activate either the whole worksheet or a range to make the links active (hyperlinks).
I've tried all sorts of macros to accomplish this but can't seem to get it.
ie.
Code:
[URL unfurl="true"]http://www.msn.com[/URL]If I click into the cell, (as if I were going to edit), and then click out, the text (
Code:
[URL unfurl="true"]http://www.msn.com[/URL]How can I accomplish this over a large scale.
tav