I,m not entirely sure what you want but if you have named a range yo
can have a dropdown list box by using DATA, VALIDATION, then choos
allow list then in the range box type =MC!

Don't forget to highlight the range you want the listbox to work o
befroe you choose validation.

Hope this helps!

Simo

--
Message posted from http://www.ExcelForum.com