Data Validation and Pasting

**Jim28** · 06-23-2011, 05:46 PM

Dear all

What is the simpliest way to stop data validation not working when data is pasted into the data validation cell?

Thanks.

Jim

**martindwilson** · 06-23-2011, 06:55 PM

not simple see here
http://j-walk.com/ss/excel/tips/tip98.htm

**Jim28** · 06-23-2011, 07:04 PM

This doesn't prevent paste special though right?

**martindwilson** · 06-23-2011, 07:07 PM

try it!!!!!! i have no idea but it doesn't say it doesn't

**Jim28** · 06-23-2011, 07:08 PM

I have tried it and it doesn't :-)

**ron2k_1** · 06-23-2011, 11:31 PM

If you want to take your time you can Paste Special.

You can paste as values if you want the values of the data pasted or Formulas if you just want to copy the formulas and not the formats. You do that by copying the source range, then go to the destination range and right click and select Paste Special