worksheetfunction.index array form

[SBF12345]

I am working with the lines:

ArrX = Application.WorksheetFunction.Index(X, 0, 2)
    ArrTemp = Application.WorksheetFunction.Index(TempSample, 0, 2)
DistanceMeasure = (1 - Application.WorksheetFunction.Correl(ArrX, ArrTemp)) * 100

I would like to be able to run a simple correlation using arrays with a variable length of objects defined by worksheet inputs and dim as variant. My goal is to be able to run the correlation using all the values in the variant X and variant TempSample. Both have the same number of objects.

what is the correct syntax to do so?

when I do the correlation calculation long hand my values are different. Thanks!

 

[SBF12345]

For gg = 1 To NumObs    
    ArrX(gg) = Application.WorksheetFunction.Index(X, gg, 2)
    ArrTemp(gg) = Application.WorksheetFunction.Index(TempSample, gg, 2)
    ArrX1(gg) = Application.WorksheetFunction.Index(X, gg, 3)
    ArrTemp1(gg) = Application.WorksheetFunction.Index(TempSample, gg, 3)
    
    Next gg

I added this code and it seems to be loading the arrays fine.