Ask a new question

Remove FriendlyName from Hyperlink via Function or Macro?

I know this is an odd request.

Does anyone know how to take "Click Here" type links and show the actual URL in the text instead of "Click Here." I must be able to do this to thousands of "Click Here" links at one time, manually changing it won't do at all. It appears I need a function or macro. Is this possible?

Help --- thanks!

Answer
Answer

Someone answered my questions on the Facebook fan page for Excel:

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

http://excel.tips.net/Pages/T003281_Extracting_URLs_from_Hyperlinks.html

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 28, 2024 Views 3,133 Applies to: