There needs to be an GETHYPERLINK function that lets you reference the hyperlink that is alreday associated with a cell.
For example if the contents of cell A1 =HYPERLINK("https://www.microsoft.com","Microsoft Home Page")
Then there needs to be a way to put in cell B1 =GETHYPERLINK(A1) which would return "https://www.microsoft.com" without needing to do it in VBA.
Kenneth Barber commented
I ran into this problem for a client and had to write a quick and dirty macro to add the capability. A built-in function would be greatly appreciated!