If you give a few details about what has stopped working, and what you
did with autofill, someone may be able to suggest a solution.
If the dropdown arrows have stopped appearing, there are some possible
causes and fixes here:
http://www.contextures.com/xlDataVal08.html#ArrowsNotVisible
> 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?

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html