I did this to fix the problem. Please tell me if this method is correct
and fool-proof.

Book 1 is where my validation is. Book 2 is where my data is. In book
2, i highlighted the data and defined it as 'report'. In Book 1, i made
another Name (Define) which goes to Book2 and gets 'report'; i name this
"City". Then in data validation, i can enter City and it works!


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=573743