I have a spreadsheet that is drawing from an Access database.

The user has a main choice, then for some of the main choices there are sub
selections. If there are only a couple, I can write an if to select the
different ranges on the Data Validation dialog box. But I'd like more
indpendence. When the database is tied I download tables. So if the main
choice has a sub selection, I have the letters that are the suffixes to the
range names with the various sub menus.

Here's an example of what I'd like to do:

MenuSuffix="WC"
=IF(MenuSuffix="",Range("A1"),"Index" & MenuSuffix)

Just how do I turn "Index" & MenuSuffix into the range value?

Don <www.donwiss.com (e-mail link at home page bottom).