CODEWITHSUNDEEP
excelvalidationcopy-paste
Kuroh
Kuroh

Reputation: 173

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)

Upvotes: 3

Views: 13719

Answers (1)

Lance Roberts
Lance Roberts

Reputation: 22842

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

An example of some code is at this SuperUser link.

Upvotes: 1

Related Questions