Prevent duplicate entries

How can I prevent a duplicate value from being entered in a worksheet?

Teri

See Chip Pearson's site.

http://www.cpearson.com/excel/NoDupEntry.htm


Gord Dibben Excel MVP

On Thu, 3 Mar 2005 09:45:12 -0800, "Teri" <Teri@discussions.microsoft.com>
wrote:

>How can I prevent a duplicate value from being entered in a worksheet?