Thanks for your help Tom. That works well, however if anyone else i
going to use the code, please note a small typo in Tom's suggeste
code. Under "ErrHandler" it should read "Application.EnableEvents
True" not "Application.EnableEvent = True
--
Peter
-----------------------------------------------------------------------
PeterW's Profile:
http://www.excelforum.com/member.php...nfo&userid=649
View this thread:
http://www.excelforum.com/showthread.php?threadid=57163