Please help. I have a workbook with columns of email hyperlinks that I imported from another program.
When I run following macro: My cells show what is in the "Text to display field". I need to see the email address.
I have spent many hours searching the web for a macro to do this but I cannot find one. And I do not know how to do it my self.
Thanks,
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Bookmarks