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.