Hello,
I have an OpenOffice Calc (spreadsheet) that has over a thousand
Hyperlinks and I would like to create a user defined function which
would extract the URL from the Hyperlink and put it in a separate cell.
I found an Excel example on the web which I pasted in below.
Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function
Can this be done in OpenOffice Calc? I have looked for documentation but
I probably using the incorrect terms so I have not found any
information. I use both the Windows and Mac versions of Open office.
Thank you. I enjoy reading the support you provide to users and I have
learned several things. dds
