Selecting a single column of a multi-dimensional array

[hmatharo]

Hi,

Is there a way to tell VBA to work with all the rows in a single column of a multi-dimensional array?

My problem is I have a multi-dimensional array that contains data that I want to do some calculations on. Let's say the array has 10 rows and 5 columns. If I wanted to take the average and standard deviation of each column individually, how would I do that?

What I had in mind was something like this...

For i = 1 to no_columns
avg_temp = application.worksheetfunction.average(array_values( ? , i)
stdev_temp = application.worksheetfunction.stdev(array_values( ? , i)
next i

I don't know how to tell VBA that I want to take into account all the rows from column i of the array. Any help would be greatly appreciated.

Thanks.

-HSM

[shg]

1. Please edit your post to add code tags.

2. The Index function (available to VBA) with one value set to zero will return a row or column of an array.