Copy values to validated cells

Closed
Prem - Oct 15, 2010 at 04:20 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 15, 2010 at 12:31 PM
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 May 23, 2009 Status Contributor Last seen October 20, 2010 183
Oct 15, 2010 at 12:31 PM
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?
0