This function enumerates assumption cells for all open workbooks. This command is useful for determining what assumptions have been defined for the open workbooks. You can then call CB.GetAssum for each assumption to retrieve specific information—for example, distribution type and parameters.
Table 59. CB.EnumAssum Returned Data Type
The absolute cell reference of the next assumption, in the format: '[workbook]sheet'!$A$1 |
Note: | For best results, call CB.CheckData once at the beginning of an enumeration to reset the sequence of assumptions. You should also call CB.CheckData each time you add or delete data. Use CB.CheckData or CB.CheckDataND with CB.MacroResult and CB.MacroResultDetail to check for errors. For more information, see the descriptions of those calls. |
If the return string is empty, all assumptions have been enumerated. You can use the results of this subroutine 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.