Only Allow Copy Paste for Cells with Data Validation

**dreamwarden** · 10-12-2018, 04:39 AM

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** · 10-12-2018, 11:58 AM

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...)

Only Allow Copy Paste for Cells with Data Validation

LinkBack

Thread Tools

Rate This Thread

Display

Only Allow Copy Paste for Cells with Data Validation

Re: Only Allow Copy Paste for Cells with Data Validation

Thread Information

Users Browsing this Thread

Similar Threads

Prevent copy and paste invalid data for data validation cells

Allow to copy and paste only valid data over data validation cells

Allow to copy and paste only valid data over data validation cells

Copy & paste with data validation

[SOLVED] change validation list value and copy and paste from dependent cells

[SOLVED] Protect Data Validation cells from Copy Paste

validation rules not working when someone copy paste data on validation cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions