displaying the text from a URL on the cell

Hi,

I am sorry if this has been discussed before, I did make a search for it, but found nothing, so here it goes!

I have a sheet of >5000 lines. One row displays hyperlinks. By pressing on it, default browser comes up.

The problem is that instead of displaying the url (i.e. http://www.google.com) it displays the name of it (i.e. google) in blue.

Is any way of automatically displaying the URLs of those fields?

Please save me!

Hi,

Have you tried

Please Login or Register  to view this content.

HTH
Carim

Originally Posted by Carim

Hi,

Have you tried

Please Login or Register  to view this content.

HTH
Carim

I am actually not into vb macro programming. _If_ this is the only solution, would you be so kind by giving me the code to modify the "TextToDislpay" property for (let's say) a range of "F1" to "F5000"?

Originally Posted by VBA Noob

Hi,

Save a copy of your sheet the in the copied workbook enter this VBA code

Alt + F11
New Module

This will remove the text and leave only the Hyperlinks

VBA Noob

This is sooo cool!! It works like a charm... Thank you so much!

I also added

hlink.Delete

in order to remove the blue link totally!!

thanks again!