Tom, thank you for that script, it works perfectly!

Another question.... is it possible to make the result look like
link, instead of just text? After I run the function, the cel
contents are still black, not the 'expected' blue. It's still a lin
but could be made more intuitive by changing its color. Any way to d
that? Thanks again!

pau

--
tsuoyin
-----------------------------------------------------------------------
tsuoying's Profile: http://www.excelforum.com/member.php...fo&userid=2011
View this thread: http://www.excelforum.com/showthread.php?threadid=34681