please refer to this post to prevent dupilcates http://www.mrexcel.com/forum/showthread.php?t=322724