Hi,

I am totally new to VBA and started my carrier just now. I have a excel that contains tables. In the table all the cells have data validation. I need to write a code to avoid invalid data entries in the cells. If i just type other than the entries that are in the data validation list it will throw an error but if i copy and paste from another excel or notepad it is allowing the invalid entry.

So please help me how to avoid this.

Thanks in advance.