In this macro enabled sheet i have data validations for columns where i want to regulate the data input. The problem i am facing here is that, Considering scenario where the customer wishes to copy data from another excel file. Implementing this scenario i have copied some data from a foreign excel to my data validations enabled sheet. I have a column where the user can input only text length less than 9 but when i copy the data say text length greater than 9, such scenarios do not seem to show any error message. Is there a workaround which would help me overcome this situation?