johnpdavey
Board Regular
- Joined
- May 30, 2002
- Messages
- 88
i have set up a sheet that contains data validation so that values above a specified amount generate an error message. (all the entries in A2:A200 are referenced to a maximum value in cell A205, B2:B200 to a value in cell B205, likewise for cells C2:BD200)
this sheet works fine when data is entered one piece at a time.
when i paste a large set of data into the area covered by the data validation no eror messages appears even though some of the entries exceed the validation criteria.
i have to search and find the invalid entries even though the data validation is still in force(if i change one of the pasted entries to an incorrect entry the validation error message appears.)
is there any way of highlighting incorrect data that has been pasted so that i dont have to search myself?
i am suprised that the data validation function does not do this!
thanks in advance for your help.
ps i would rather avoid VBA if possible, i still havent got a handle on that yet.
this sheet works fine when data is entered one piece at a time.
when i paste a large set of data into the area covered by the data validation no eror messages appears even though some of the entries exceed the validation criteria.
i have to search and find the invalid entries even though the data validation is still in force(if i change one of the pasted entries to an incorrect entry the validation error message appears.)
is there any way of highlighting incorrect data that has been pasted so that i dont have to search myself?
i am suprised that the data validation function does not do this!
thanks in advance for your help.
ps i would rather avoid VBA if possible, i still havent got a handle on that yet.
