Standard Deviation of an array

[jumpbackjack]

I have an array arrData(800,15). I want to find the standard deviation of the data in arrData(800,10). Is there a way to do this without entering 800 rows in an excel spreadsheet and using STDEV.S there? Thanks.

[arnelgp]

have you seen this:
VBA: Multidimentional Array Syntax for STDEV Evaluation | MrExcel Message Board (https://www.mrexcel.com/board/threads/vba-multidimentional-array-syntax-for-stdev-evaluation.812406/)

[p45cal]

sd = Application.StDev_S(Application.Index(arrData, ,10))