Search code examples
excelvalidationcopy-paste

Excel Copy and Paste while maintaining data validation

When I perform a copy and paste from a blank cell to a cell with data and validation, the validation in the destination cell itself gets deleted.

Is there anyway I could maintain the validation in the destination cell while only pasting the values? (And validating the contents that are pasted)

(Also, and hence the reason why I ask this, I'm not allowed to use the "Paste Special" feature, so a workaround is required)

Solution

  • You have to use VBA (create a macro) to be able to do this.

    An example of some code is at this SuperUser link.