Actually, what would I have to change if i want the loop to ru
continually until the user enters an employee name that is unique (no
found in the range)?

I have tried to amend your answer in diferent ways including using
new variable if there is a duplicate found, but can't quite get it al
together (!)

Thanks for your help

Dav

--
Applewin
-----------------------------------------------------------------------
Applewine's Profile: http://www.excelforum.com/member.php...nfo&userid=551
View this thread: http://www.excelforum.com/showthread.php?threadid=39758