data validation

  • Thread starter Thread starter aza
  • Start date Start date
A

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
 
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.)
 
Back
Top