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:
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")
But it gives me "Subscript out of range" error. Could you please help me with this error please?
Thanks
Bookmarks