You'll need to use a named range. Look he
http://www.cpearson.com/excel/named.htm

for ideas on how to write the formula that governs your range

You basically need a range that uses the OFFSET function, and is determined
by the value of your cell.(maybe some use of MATCH or LOOKUP?)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CDnook" wrote:

I am trying to use a combo box which will provide a range of selections
depending on the value of a cell. If the cell say "Dallas" the combo box will
present different options than if the cell says "Houston".