Are we talking about a specific range or anywhere on the sheet?

--
Rick (MVP - Excel)


"RaulDR" wrote in message
...
Hi All,

I created a worksheet which has a validation that prevent duplicate
entries.
The validation is working fine if the user types the value. My question is
how can I make excel to validate the values that the user copy from
another
worksheet and paste to my worksheet.

Thanks!