Excel Copy and paste when confirming data

Question

When I perform a copy and paste from an empty cell into the data and validation cell, the validation in the destination cell itself is deleted.

Anyway, could I support validation in the destination cell just by inserting values? (And checking the content that is inserted)

(Also, and therefore the reason why I ask about it, I am not allowed to use the Paste Special feature, so a workaround is needed)

+3

Kuroh Jun 14 '11 at 14:41

1 answer

Lance roberts · Accepted Answer · 2011-06-14T14:54:29+0000

For this you need to use VBA (create a macro).

You can change the code related to Craig A in the comment ( j-walk.com/ss/excel/tips/tip98.htm ).