I am using the following VBA function to turn a link into a URL
Function GetURL(cell As Range)
GetURL = cell.Hyperlinks(1).Address
End Function
I get #VALUE
as a result
I believe it is because there is an “=” sign in the URL. Is there any way to correct this?