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 reply

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