Data validation does not seem to work with copy/paste

L

LAF

I have set up some data validation for each cell within a range. When
manually enter invalid data in one of those cells, the data validatio
works and an error message pops up. When I copy from one cell wit
data to another cell, where the data validation results in false, i
allows me to paste the value with no error message. Is there any wa
to fix this
 
Top