Tom,

that is true, it only checks Data Validation sheet intergrity, i.e.
when you have say a whole column(range) with one certain type of
validation, and you paste in a cell into that column with a different
type of validation from somewhere else, the code should block this
because it checks for the continuous range with the same validation.
For just one cell this is not a solution so this code will not help
there.

A trick that *could* be used is use my code and create a range of say 2
cells with the same validation, the second being a dummy cell that is
actually not needed for anything but the checking for a continous
validation range. Then my code would work as long as the enduser only
pastes his value in 1 of the 2 cells. Since this would mean both cells
have different validations, the code will spot this and cancel the
action.

Hope this clarifies it a bit

DM Unseen