Unable to get the correl property of the worksheet function class

[SBF12345]

I am having trouble with the line below

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

X and TempSample are both arrays with an equal number of elements. Am I using "application.worksheetfunction.index" correctly? I am trying to return the entire column in the array, the second column.

Ideas?

 

[SBF12345]

I think I have it working good now. I changed the second argument of the UBound defined integers to "1". I ran it a few times and had some trouble with the correl line, then I changed the option base to 1, and now it seems to be working fine.