Restrict Duplicate Values in a Row using excel VBA

[msampath]

Hello All,


I want to restrict the duplicate entries in the entire row,this should also work when we copy and paste cells.Kindly provide me solution


Example:


Suppose the Range is A1 to AC1 then if A1 contains sam(correct) ,b1 contains sam1(correct),c1 contains sam(Incorrect) so i should restrict c1 by entering duplicate values need to check untill AC1.



Thanks & Regards,
Sampath

[snb]

crossposted:

http://www.mrexcel.com/forum/excel-q...lications.html