Copy values to validated cells [Closed]

Report
-
Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

I have validated a cell to contain certain values only, say 1 and 0.
But if i copy any value from anywhere and paste in the validated cell, it's just accepting without validations.
Please help me in what needs to be done

1 reply

Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
243
please explain what you are trying to do.

if you copy and paste all you do is over write the cell that you have added validation to, there fore your validation rule will be deleted.

do you have an example of what you are trying to do?