Creating an Array with Names instead of Index Numbers

[redbrad0]

In c# .net I can create and array with using the name like arrayNames("John") = "john@me.com" but in excel VBA I cant find any documents that say this is possible as everything seems to reference the index number of the array. Basically what I am trying to do is read in settings for the excel file from the settings Worksheet I created so we a new column is added, the setting is automatically read into the application with the name of it. So then when I want to know the value of setting ABC I can just call arrayNames("John"). Is this possible?

Example:

Please Login or Register  to view this content.

[Bob Phillips]

Try using a collection instead.