>> Would you mind zipping and uploading here?
Hey Anne, that's a good question. The wb contains ;
1. Data Validation
2. VLOOKUP thru VBA
3. Worksheet/event code
4. Dynamic named ranges
You've already covered 1 and, to a degree, 2 on the web. Re: 3, I don't do proper code, so I'm not sure it would be a good idea to put it in the public domain -- might do more harm than good.

Plus it would cause work for ppl who
do do proper code, having to point out what's wrong w/it (mentioning no names, but I'm thinking palm trees, leis, etc.

; no offence intended).
That said, 4 can be v useful IMO. So if it ended up being tweaked (from feedback) into something generic that added some value, then it might be worthwhile.
What say you?
Rgds,
Andy