How do I get Hyperlink from a cell
 

How can I get the hyperlink value from a cell? The cells
hyperlink was put in at the insert hyperlink command not
the function.

How do I get Hyperlink from a cell
 

activecell.Hyperlinks(1).Address & " " & activeCell.Hyperlinks(1).SubAddress

--
Regards,
Tom Ogilvy

"Michael Kintner" wrote in message
...
How can I get the hyperlink value from a cell? The cells
hyperlink was put in at the insert hyperlink command not
the function.

How do I get Hyperlink from a cell
 

Thank you very much!!
Have a great day....

"Tom Ogilvy" wrote in message
...
activecell.Hyperlinks(1).Address & " " &
activeCell.Hyperlinks(1).SubAddress

--
Regards,
Tom Ogilvy

"Michael Kintner" wrote in message
...
How can I get the hyperlink value from a cell? The cells
hyperlink was put in at the insert hyperlink command not
the function.