This function returns the correlation coefficient defined between two assumption cells.
Note: | For best results, call CB.CheckData before calling this function to ensure the latest data values are used. |
Table 102. CB.GetCorrelation Returned Data Type
Returned Value | Returned Data Type |
|---|
The correlation coefficient of the two assumptions | Variant |
If a correlation between the assumptions wasn’t defined, this function returns the value 2.
Table 103. CB.GetCorrelation Parameters
Parameter | VBA Data Type | Value | Description |
|---|
AssumReference | Variant | In a macro: Range("B3") | Points to one of the correlated assumption cells |
Column | Integer | Any number up to 256 | Points to the column of the second correlated assumption |
Row | Long | Any number up to 64,000 | Points to the row of the second correlated assumption |