If you paste the text into the formula bar, it'll be treated as typing.

If you paste a cell over that cell, then you're copy|pasting all the attributes
from that "sending" cell--including overwriting the data|Validation rules.

Another way around this is to remove the data|validation and put all the
validation into a worksheet_change event.

rjshelby wrote:

When I paste data into a cell the data validation does not work. Is there any
way to validate data when it is pasted? Thanks for any help on this question.

--

Dave Peterson