data validation

A

aza

created a cell with validation not to accept invalid data. This seems to work
fine within the same sheet. BUT when invalid data is copied from another
sheet in the same cell using (Paste Special - values) , validation is not
performed.

any suggestions
 
D

Dave Peterson

Data|validation is not very robust (as you've seen).

Maybe you can copy from the formula bar and paste into the formula bar?

Or remove the data|validation and replace it with some kind of worksheet_change
event. (Which fails if the user disables macros or events.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
2007 data validation not working 1
[err] Excel 2007 - Data validation from another sheet? 1
Data Validation in another sheet 1
copying data validation to another workbook 3
data validation error alert does not work 2
VLookup using lookup table 1
Data Validation Error 1

Top