Terry_Orange
Board Regular
- Joined
- Jul 22, 2002
- Messages
- 133
Hi folks,
I have an excel sheet with thousands of hyperlinks.
In a seperate sheet I have a list of some of these websites named, which I VLOOKUP and find. I then want to copy across the actual hyperlink (and print out the text for a user to see).
YAHOO (www.yahoo.com)
I can find it fine, but I can't access the hyperlink information to copy it across. I can add a hyperlink - but I don't know how to assess the original...
activecell.hyperlink. ????
Any ideas anyone !?!?!?!?!
THANK YOU AS ALWAYS.
TO.
I have an excel sheet with thousands of hyperlinks.
In a seperate sheet I have a list of some of these websites named, which I VLOOKUP and find. I then want to copy across the actual hyperlink (and print out the text for a user to see).
YAHOO (www.yahoo.com)
I can find it fine, but I can't access the hyperlink information to copy it across. I can add a hyperlink - but I don't know how to assess the original...
activecell.hyperlink. ????
Any ideas anyone !?!?!?!?!
THANK YOU AS ALWAYS.
TO.