Only Allow Copy Paste for Cells with Data Validation

[dreamwarden]

Hi Everyone,

I found this macro which allows me to only allow copy-paste values in order for data validation to work. However, this is only one cell. How can i convert to make it work for a range of cells?

Please Login or Register  to view this content.

I tried changing the code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

but I'm getting the message Application-defined or object-defined error. Could anyone please help me how i can rewrite the code?

[Bernie Deitrick]

Your code, and its modification, worked for me - make sure that your named range DVLists exists and is named exactly that, and that it is in the codemodule of the worksheet with that named range. (Event code does not go into standard codemodules...)