Hi,
When I am passing a range to the below UDF, say A1=CorrelationCoefficient(B1:C100, 1, 2, 0) I am getting an VALUE error. Any reason why?
The code is:
Public Function CorrelationCoefficient(MyArray() As Double, Optional asX As Long = -1, _
Optional...