Arrays and Functions

[NatalieEC]

Hello,

My problem is still kind of confusing because I am still trying to figure out exactly what it is I want to do.

I have multiple columns of data. I would like to plot each column against time. However, these columns in the future may be made longer, and I would like to "do math" in some of these columns. I don't want "the math" to update the columns.

Therefore, I had the idea of making arrays. I could find the number of rows in the columns, pass that number as the number of elements in the array to a function (which does the math I want) and return that array.

Anyhow, I am getting errors! A subscript out of range error.

Please Login or Register  to view this content.

[MarvinP]

Hi,

Here are some quick observations:
Arrays need to be Dim as Variant
Arrays are zero based, meaning they start with Ary(0) not Ary(1)

You can find the lower and upper bound of an array by using LBound(Ary) and UBound(Ary) to see how big the array is.

The above hints might lead you to finding your "subscript out of range" problem.

[NatalieEC]

Thank you! That certainly cleared up a lot of my problems.