Copy values to validated cells

Closed
Prem - 15 Oct 2010 à 04:20
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 15 Oct 2010 à 12:31
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 response

sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183
15 Oct 2010 à 12:31
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?