Dear all

What is the simpliest way to stop data validation not working when data is pasted into the data validation cell?

Thanks.

Jim