Visit Chip Pearson's site for a Data|validation solution:
http://www.cpearson.com/excel/NoDupEntry.htm



TimE wrote:

I would like to prevent duplicates from being entered. If a duplicate
is entered (attempted), a message box will be displayed indicating the
row # of the original entry.

Cell A1 contains 1234

I try to enter 1234 in cell A223. I want a message box to appear
informing me of a duplicate at Row 1.

Thanks in advance for any assistance.

TimE.

--
TimE

--

Dave Peterson