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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to open new window within document 0
Hyperlinking automatic?? 1
You'll need a new app to open this about link 1
Eliminare un fastidioso avviso di sicurezza 0
Word hyperlinks not working 2
AppleScript - How do I select a text ? 1
Hyperlink fails to open on the first click 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0

Top