How to validate copy/paste data
 

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?

How to validate copy/paste data
 

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?

How to validate copy/paste data
 

is there any way to apply validation on coping an pasting?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=530784