This function enumerates decision variable cells for all open workbooks. This command is useful for determining what decision variables have been defined for the open worksheets. You can then call CB.GetDecVar for each decision variable to retrieve specific information—for example, range minimum or maximum.
Table 64. CB.EnumDecVar Returned Data Type
The absolute cell reference of the next decision variable, 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 decision variables. You should also 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 decision variables 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.