Hi. I am basic excel user so I hope you can help me.
I found this macro online and it works perfectly in my needs.
This macro will give the path for a link but when I run it, I need to click Alt F11+ F5
I want to have a button on the sheet so user will just click it and run automatically.
Here is the macro:
Function GetURL(cell As Range, _
Optional default_value As Variant)
'Lists the Hyperlink Address for a Given Cell
'If cell does not contain a hyperlink, return default_value
If (cell.Range("A1").Hyperlinks.Count <> 1) Then
GetURL = default_value
Else
GetURL = cell.Range("A1").Hyperlinks(1).Address & "#" & cell.Range("A1").Hyperlinks(1).SubAddress
End If
End Function
Bookmarks