Perhaps you can try this?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=227

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


wrote in message
...
I have a large excel sheet where one column contains hyperlinks. They are
all of the form:
Map_This
and I'd like to substitute the underlying URL so that I can save this to a
text file and put it in a database.

Anyone have an idea? What I don't want to do is to do them all manually by
right-clicking, editing the link and
cutting and pasting the URL in the "display as". I tried making a macro,
but I can't figure out how to make a macro
that works in all columns as opposed to just a single cell.

TIA.




----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---