Grateful for your help. Problem solved. I had worked around it b
overwriting (from within the macro) the contents of the relevan
cell-link cell, but your simple instructions are much tidier. Thank yo
for taking time to help.

Richard Clayto

--
Richard Clayto
-----------------------------------------------------------------------
Richard Clayton's Profile: http://www.excelforum.com/member.php...fo&userid=1512
View this thread: http://www.excelforum.com/showthread.php?threadid=26761