« Microsoft Excel cannot open or save any more documents | Additions/Removals of Functions in Excel 2016 » |
Extract Hyperlinks In Excel (a quick tip)
VBAHi there,
In this post, I will explain how to extract hyperlinks from Excel.
MANUAL EXTRACTION:
We can extract hyperlinks by right clicking on the word/sentence which contains link and choose "edit hyperlink" and then copy the link in the "address" place as shown in the pic below.
...
AUTOMATE EXTRACTION:
We can automate this scenario using vba code as given below.
Sub ExtractHyper()
Dim Hyper As Hyperlink
For Each Hyper In ActiveSheet.Hyperlinks
Hyper.Range.Offset(0, 1).Value = Hyper.Address
Next
End Sub
This code will help you to extract the hyperlinks in excel.
If you are new or confused how to use this code in excel, then here you go:
1. Press ALT + F11 on the opened excel workbook which contains hyperlinks
2. Copy the code and paste it on a new module in Insert Option.
3. Finally, Press ALT + Q to exit from the vba window.
I have learnt this because I had a requirement today with my client. If you have the same requirement, use this technique and help your friends who might get needy using social networking sites placed around the blog.
DID YOU LIKE "ËXTRACT HYPERLINK IN EXCEL"?
Please share your thoughts or views about this post using below comments section. If you like this post, you can share it on your social networking sites by clicking on the icons placed around the blog.
To receive such updates, JOIN OUR FAMILY,.
SOME IMPORTANT LINKS:
Count Colored Cells using Simple Function
Count Worksheets in a Workbook
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments