Abstract URL from Hyperlink
Point No. 1:- First open new
excel sheet.
- First method:- press window+r-->write "excel" without double quote--> press enter.
- Second method:- If any excel sheet already open simply press ctrl+n;
- Third method:- press window key and type excel in search box.
Point No. 3:- Press Alt+F11
to open Microsoft visual Basic.
Point No. 4:- Now go to
insert main menu --> select module
Point No. 5:- A module page
open. Paste below code in module
Public Function
URL(take_range As range) As String
On Error Resume Next
URL = take_range.Hyperlinks(1).Address
End Function
Point No. 6:- Now run this
program. There is 2 way to run microsoft visual basic program.
- First way:- Go to main menu--> select run sub/UserForm.
- Second way:- Simiply press F5.
Point No. 7:- A Micros popup window open. Simiply close it and press Alt+Q
Point No. 8:- Now back to
your sheet and use URL() funtion as shown below.
Point No. 9:- Then press enter and press Ctrl+D to duplicate function downward.
Notes:- You can do it with exist
excel workbook (current excel) without create a new workbook. If you do it with exit excel
workbook just start from point no 3.
Finish Tutorial....
