You are light on details. But basically, you would need to check after or
as part of a change, that the new value is not a duplicate. Chip Pearson's
provides several generic techniques which might offer some ideas you can
use:
http://www.cpearson.com/excel/duplicat.htm

another page of interest might be on utilizing events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy



"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:%23562gTSFGHA.1180@TK2MSFTNGP09.phx.gbl...
> I've got almost 30 ranges in my worksheet. No value should be duplicated
in
> any of these ranges. Is there a convenient way, either with a worksheet
> function or a VBA method, to monitor this for each range? Or do I need to
> loop through each cell of each range on a regular basis to see if I've
got
> duplicates?
>
> Ed
>
>