declaring 2darray in excel vba
I need to declare a 2d array purely in VBA to cater for checking an incoming file for completeness.
each line of the array would be of strings such as "Person ID", "BE"
I know the complete list would be limited to 17 items so "colArray(1 to 17, 1 to 17) as String" is accepted but then I get constant expression problem when I try to populate the array.
In my simple mind I envisaged it to work with first setting the array constraints and then populating the array with such as colArray = ("person ID","BE";"Reference","CB"; et cetera....)
Any help please in pointing in right direction would be appreciated.