Thanks for that

But how do I do it in VBA so the user does not have to manually updat
the links?

Ro

--
rothc
-----------------------------------------------------------------------
rothco's Profile: http://www.excelforum.com/member.php...fo&userid=3149
View this thread: http://www.excelforum.com/showthread.php?threadid=51170