This function enumerates forecast cells for all open workbooks. This command is useful for determining what forecasts have been defined for the open worksheets. You can then call CB.GetFore for each forecast to retrieve specific information—for example, the forecast name and units.
Table 65. CB.EnumFore Returned Data Type
The absolute cell reference of the next forecast, in the format: '[workbook]sheet'!$A$1 |
Call CB.CheckData once at the beginning of an enumeration to reset the sequence of forecasts. Call CB.CheckData each time you add or delete data. Use CB.CheckData or CB.CheckDataND with CB.MacroResultDetail to check for errors. For more information, see the descriptions of those calls. |
If the return string is empty, all forecasts have been enumerated. You can use the results of this function to create a Range object.
You can only call this function from a subroutine or another function. You cannot call this function from a worksheet.