I'm using Debra Dalgleish method to enable autocomplete in a drop-down list
data validation (http://www.contextures.com/xlDataVal11.html). The problem
with this solution is that every time I try to use de Copy/paste function it
gets disable when i move into another cell. How could it be prevented???.