PDA

View Full Version : Restrict Duplicate Values in a Row using excel VBA



msampath
04-06-2016, 02:11 AM
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
04-06-2016, 03:00 AM
crossposted:

http://www.mrexcel.com/forum/excel-questions/932712-restrict-duplicate-values-row-using-excel-visual-basic-applications.html