hyperlinks and filenames

  • Thread starter Thread starter Elin
  • Start date Start date
E

Elin

Hi!

If I got a hyperlink can I, by using a formula, get the
filename of the hyperlink?

Kindly regards
//Elin
 
Hi this should work

Function hyperlinkAddress(Cell1 As Range)
hyperlinkAddress = Cell1.Hyperlinks.Item(1).Address
End Function
 
Back
Top