How do I get Hyperlink from a cell

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

How can I get the hyperlink value from a cell? The cells
hyperlink was put in at the insert hyperlink command not
the function.
 
activecell.Hyperlinks(1).Address & " " & activeCell.Hyperlinks(1).SubAddress
 
Thank you very much!!
Have a great day....

Tom Ogilvy said:
activecell.Hyperlinks(1).Address & " " & activeCell.Hyperlinks(1).SubAddress
Click to expand...
 
You must log in or register to reply here.

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

sheet event wait for another event? 6
Find the row for a Hyperlink 2
Open specific hyperlink (accept) automatically in email with outlook 0
Copy hyperlinks 6
add hyperlink without changing the cell formating 6
HOW: Click Formula Hyperlink To Trigger Macro 1
No characters data in Hyperlink cell 3
Help with hyperlinks 2

Back
Top