Prevent duplicate data using VBA

[jishar]

Hello,

I would like to get the code to prevent pasting duplicate data in excel using VBA.

 

[Joe4]

Welcome to the Board!

There is another very similar question asked just a little while ago, also missing the important details.

How many columns are your data?
What constitutes a duplicate (do all columns need to match, or just certain ones)?
How exactly is the data being copied? If by VBA code, please post your code.

 

[Joe4]

It appears that this seems to be a school/homework assignment that a lot of people are asking about.
There are 4 of you who all joined yesterday, all located in the same city, all asking similar questions:
https://www.mrexcel.com/forum/excel-...vba-excel.html
https://www.mrexcel.com/forum/excel-questions/1055776-vba-preventing-duplicates.html
https://www.mrexcel.com/forum/excel-questions/1055758-removing-duplicates.html

Note that while people may be willing to give you "hints" or point you in the right direction, please do not expect people to complete your homework assignments for you.