Hello, I am writing a VBA code to calculate basic statistics for several arrays.
so I have a table, having 3 columns: PAR1, PAR2, PAR3
And say I want to calculate their mean and variance.
I have defined "HeaderTitleTotal", "ary_1_values", "ary_2_values" and "ary_3_values" arrays in excel and now I'm refering to them in my code:
But it gives me "Subscript out of range" error. Could you please help me with this error please?![]()
Dim ParameterArrrayRange() As Variant ReDim ParameterArrayRange(HeaderTitleTotal) Set ParameterArrrayRange(1) = Range("ary_1_values") Set ParameterArrrayRange(2) = Range("ary_2_values") Set ParameterArrrayRange(3) = Range("ary_3_values")
Thanks
Bookmarks