Hi Joel,
Assume you want to extract the hyperlink out of object type hyperlinks
you would be best using a User Defined Function. Function and usage at

http://www.mvps.org/dmcritchie/excel...perlinkaddress

link to Instructions to install are at the top of the that page.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"joel anthony" wrote in message
...

Thanks in advance
I want to copy my excel hyperlink column from a sheet into an access
table.
The whole address does not come across and does not function. Any
suggestions would be appreciated.
joel


--
joel anthony
------------------------------------------------------------------------
joel anthony's Profile: http://www.excelforum.com/member.php...o&userid=33728
View this thread: http://www.excelforum.com/showthread...hreadid=535076