I have a column of text which are all hyperlinks. I want to copy the text and url into seperate fields.
For Example Cell(A1) has "Apple" (hyperlink to http://www.apple.com)
I want to put the values into D and E
D1 would contain "Apple"
E1 would contain the URL http://www.apple.com
Function GetURL(HyperlinkCell As Range) GetURL = Replace(HyperlinkCell.Hyperlinks(1).Address, "file:", "") End Function
I tried this in ThisWorkbook (VBA) and I got the results as #NAME? in my spreadsheet