Excel Data Validation - copy command overwrites

L

listmic

I have several columns within a worksheet that have data validations.
When a user copy/paste or cut/paste data into the cell. The dat
validation is lost.

I would like to allow copy/paste or cut/paste into the column an
maintain data validation. Can this be done and if so how?

thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - copy/paste 3
data validation and copy/paste....... 3
Hide column based on data validation 0
Disable Cut/Copy/Paste in Excel 2010 0
Copy/Paste and remove blanks VBA 0
Data Validation - Do not want to allow pasting into the cell 3
Check Validation via Excel VBA code. 2
Protect all cells but allow data validation dropdown change 10

Top