while playing around, i did something that seems to have disabled my
"data-validation" drop down list in a range. it seems to have something to do
with auto fill. can anyone perhaps help?