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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"keithb" <k31thb@yahoo.com> wrote in message news:udteP9EnFHA.3380@TK2MSFTNGP12.phx.gbl...
> Is there some way to force unique values in a range of cells?
>
> Thanks,
>
> Keith
>