Extract a column from 2d array into 1d array

Hi guys, i am struggling with the following:
I have a VarMatrix (2d array). I want to find stdev of each column and write the result into VectorMatrix (1d array). Then I want to find min value in the VectorMatrix

PHP Code: 

For j = 5 To 16
          VectorMatrix(j) = WorksheetFunction.StDev(WorksheetFunction.Transpose(WorksheetFunction.Index(VaRMatrix, 0, j + 1)))
Next j

          K = WorksheetFunction.Min(WorksheetFunction.Index(VectorMatrix, 1, 0)) 


Sorry, I am new to VBA. Appreciate your help

Most probably problem is the types of elements in the array...
This should work.

Please Login or Register  to view this content.

Thank you for the ReDim tip, I defined an array with incorrect amount of row. Other syntax is correct. Solved

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.