Variant Arrays and Ranges of Data

[NatalieEC]

To my understanding, variant arrays are two dimensional. The first dimension for mapping a row and the second for the number of columns. If I set an array equal to range of values that is horizontal, ie:

Please Login or Register  to view this content.

Therefor, I think based on my range, that it is mapping only one row, and mapping numberOfColumns-3 columns, correct?

Later, I'd like to pass this timeArray into a function that makes a plot. The timeArray would be on the x-axis. I had this code working when the range was a column, not horizontally (had to change somethings for work).

There are three values in this array: 0,100 and 200. When I go to plot it, it only plots 0 and 100. My plotting function is below. My question is, do I need to make a new array in the function for the time?

Please Login or Register  to view this content.

[Norie]

Arrays populated from a range are 2-dimensional variant arrays, not all variant arrays are 2-dimensional.

[NatalieEC]

Okay, so if I am setting an array with a "horizontal" range, does this mean that only the 2nd dimension has all the different values. I am trying to understand why it is plotting that way.

[Norie]

Your array will have the dimensions 1 to 1 by 1 to NumberOfColumns-2.

All the items in the array will have a value if they have a value in the range.

I think you might want to change the dimension, ie the 2nd argument of UBound/LBound, you are using in your resize and loop here.

Please Login or Register  to view this content.

As it is m will be looping from 1 to 1 and yArray will have the dimensions 0 to 1.

[NatalieEC]

Hi Norie, thanks for your help! I did change the second dimension

Please Login or Register  to view this content.

[Norie]

I don't know why you are using the no of columns to determine which dimension to use.

There are only 2 dimensions in your array, you should use the 2nd.

Please Login or Register  to view this content.

[NatalieEC]

Ohhh, now I think I have a better understanding of variant arrays.

Thanks so much. I though the second number in the brackets was the number column?