Problem solved. :)

I've used a macro to extract the URLs from the hyperlinks, and put
those URLs in a new (hidden) column. I can then use the HYPERLINK
function -- which I didn't know about until just now -- on this new
column, and the hyperlinks are recreated on a different sheet.


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=384721