Also- thanks so much for this tip on the array type! I was driving myself to madness getting the "Invalid procedure call or argument" error repeatedly when I KNEW I was passing a string array...
The main problem is that array has to be a multidimensional array, your array is a single array. Also you can't redefine that type of array, you have to set it up at the beginning, so what usually do is define it at its maximum
dim summFieldArray(499,0) as variant
You would populate it with your array values so
summFieldArray(0,0) = "First Key"
summFieldArray(1,0) = "Second Key"
summFieldArray(2,0) = "Third Key"
and so on. Don't worry about the blanks, IDEA seems to ignore those.
Also- thanks so much for this tip on the array type! I was driving myself to madness getting the "Invalid procedure call or argument" error repeatedly when I KNEW I was passing a string array...
Still trying to figure out the "You must create at least one key value" error. Do you have any suggestions?
dim summFieldArray(499,0) as variant
You would populate it with your array values so
summFieldArray(0,0) = "First Key"
summFieldArray(1,0) = "Second Key"
summFieldArray(2,0) = "Third Key"
and so on. Don't worry about the blanks, IDEA seems to ignore those.
Try this out and let me know how it goes.
Brian- This worked! Thank you!
Pages