Thanks for the help. It erases the duplicate number I type in, but i
places the cursor down one row in the column. It should work fine fo
my needs though.

Again, Thankyou for your help

--
cbr
-----------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...fo&userid=3000
View this thread: http://www.excelforum.com/showthread.php?threadid=49797