That's a cool tool...but even with a dynamic named range, if the user leaves rows open (no I wasn't smart enough to do a userform...and am regretting it), they still have the possibility to type weird data into the drop down and screw things up.

Isn't there some "is not blank, then error if not in list" routine that I can add? Sorry to be insatiable over here...