This subroutine erases assumptions, decision variables, and forecasts from selected cells. The values and formulas in the cells remain.
The worksheet must be active and the selected cell or range of cells must contain assumptions, decision variables, or forecasts. If the range contains more than one type of cell, all types are cleared.
Unlike CB.ClearData, CB.ClearDataND does not ask the user for confirmation.
Note: | Before calling this subroutine, reset the current simulation and select a cell or cell range containing Crystal Ball data. |