hyperlinks and filenames

E

Elin

Hi!

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

Kindly regards
//Elin
 
R

Richard Daniels

Hi this should work

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