excel2003 validation...

[nodari]

Hi

I have validated some array to fit only numbers 1,2,..,100, but some users used to do to copy some other data into the cells.

hope you understand, the validation tools doesn't allow to write in the cell not valid data, but it does allow when somebody makes copy paste.

what can you advice not to allow to users paste there wrong data?

 

[villy]

For me using VBA codes is the best solution because Data Validation is limited for validity unlike vba..
Try it for yourself.
Thanks

 

[nodari]

For me using VBA codes is the best solution because Data Validation is limited for validity unlike vba..
Try it for yourself.
Thanks

I have used some VBA but not for this aim. and really I don't know how can I use VBA for like this problem...