Copy email behind hyperlink text

Hewlett-packard DV9000
March 13, 2009 at 06:52:21
Specs: Windows Vista
How do I copy email address behind the hyperlink text in Excel, using VBA. I want to put the email address in the cell beside the hyperlink. Using office 2007.

Best regards

See More: Copy email behind hyperlink text

Report •

March 13, 2009 at 09:10:08
I found this code that helped me a lot.
Sub HyperLinkAddressToLeft()
Dim h As Hyperlink
For Each h In Selection.Hyperlinks
h.Range.Offset(0, -1).Value = h.Address
Next h
End Sub

Report •
Related Solutions

Ask Question