This function returns the value for the given trial for a specific forecast cell.
Note: | To call this function from a worksheet, use the name CB.GetForeDataFN. |
Table 119. CB.GetForeData Returned Data Type
Returned Value | Returned Data Type |
|---|
The value of the given trial for the specified forecast cell | Variant |
Table 120. CB.GetForeData Parameters
Parameter | VBA Data Type | Value | Description |
|---|
ForeReference | Variant | In a macro: Range("B3") In a worksheet: B3 | Points to the desired forecast cell |
Index | Long | A whole number from 1 through the number of trials in the simulation | Number of the trial whose value you want to return |