That's great thank you, the bit that had me confused was the myDD.value
when it should have been myDD.object.value.
Many thanks


--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=552640