pl456 - that's what we used to do, however that's no longer possible.
Ling - if you paste one item in, then tab or enter away, yes, you get the error. But when you paste rows at a time, you don't have that "tab" or "enter" moment that does the check.
Anyway - I have a sort of solution - my...