Yes I have but no good as the list is over 250 names so validation is
bit slow...
I need a macro that overcomes this problem with autocomplete really

--
jim2

-----------------------------------------------------------------------
jim27's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=27181