Building an Array in VB

[dcanham]

Ok, here is a VB question. If you wanted to have an Array of strings the line would be....

aTestArray = Array("item1","item2","item3","item4","item5")

...what I would like to do is build an array on the fly based on variables pulled off of a sheet. How would I do that?? I tried building a string with the quotes and commas embedded and assigning that

sArrayString = sQuote + sItem1 + sQuote + "," + sQuote + sItem2 + sQuote + "," + ..............etc

aTestArray = Array(sArrayString)

....that didn't work...any suggestions?

 

[Legacy 98055]

What is the range on your worksheet? There are several ways to assign values to arrays.

Please explain what your are trying to do here instead of how you intend on doing it. There may be a better approach.

 

[dcanham]

There is a range of calls that will contain product codes (text values). These could or could not have values in them. I step through the cells, test for a value, then add the product code to the array if there is one. I will then use the built array of product codes to summarize sales data in certain ways then display them on a chart as a series. One series for each product code. I'm sure there is another way I could do it, but it seems as if I should be able to load the array in this way.

 

[Legacy 98055]

aTestArray = Array(sItem1, sItem2, sItem3)

 

[dcanham]

oh.....well duh!! I guess that could work