how can i convert a column of hyperlinks that i have to the actual addreses. for instance, i may have in one cell ebay that would link to "www.ebay.com". i would like the cells in a column, or if not another column to display in text the actual addresses and not the word, if that makes sense. can i do this via worksheet formulae or is it in the realms of vba?
Regards, jamie
Last edited by jamiepullen; 10-06-2008 at 04:21 PM.
Select the cells with the hyperlinks and run the following macro. It will put the hyperlink's address one column to the right of the selected cells. Change the second argument in the Offset to the number of columns to the right (positive number) or left (negative number) of your linked cells.
Please Login or Register to view this content.
perfect, thanks alot!
Jamie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks