It's because there is no validation for copying and pasting

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Colin Anderson" wrote in message
oups.com...
I have a worksheet and validation in each cell. Everything works great
when I am manually entering numbers into the sheet, however when data
is pasted in from another sheet it doesn't appear to do the validation.
Any thoguhts?