This example puts the correlation coefficient between G8 and G15 into cell H15.
In a macro, you can enter:
CB.CheckData Range("H15").Value = CB.GetCorrelation(Range("G8"), 7, 15)