software

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?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

quot;Colin Andersonquot; gt; wrote in message oups.com...
gt;I have a worksheet and validation in each cell. Everything works great
gt; when I am manually entering numbers into the sheet, however when data
gt; is pasted in from another sheet it doesn't appear to do the validation.
gt; Any thoguhts?
gt;
is there any way to apply validation on coping an pasting?--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=530784