Hi there,

i need some help in accessing a the ith row in a NxM array in vba. More specifically i have an NxM array called prices and i want to find the average of each row ,as well as the mean and standard deviation of each column.

Any hints ?i try using this code which sums the elements in the row and divideds it by the number of columns but it does not work when finding the stdev.

For i = 0 To NumOfYears...