Why does data validation not work when pasting data into a cell.

R

rjshelby

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.
 
D

Dave Peterson

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.
 
Top