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


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=468024