data validation

[aza]

created a cell with validation not to accept invalid data. This seems to work
fine within the same sheet. BUT when invalid data is copied from another
sheet in the same cell using (Paste Special - values) , validation is not
performed.

any suggestions

 

[Dave Peterson]

Data|validation is not very robust (as you've seen).

Maybe you can copy from the formula bar and paste into the formula bar?

Or remove the data|validation and replace it with some kind of worksheet_change
event. (Which fails if the user disables macros or events.)