I have a 10 element array named "people" and it contains the name of 10 different people. Each element of the array "people" has an unknown # of attributes.
My question is what are some ways I can store the attributes of each name so that they are linked to the corresponding name in the array?
Currently, I joined the attributes in a single string and then split them into an array when I need to use them. For example
People(0)="John"
Attribute1(0)="male , 44 yrs old, white, single"
AttributeArray=Split("Attribute1(0)", ",", , vbTextCompare)
Is there a better way?
Bookmarks