This subroutine pastes assumption, decision, or forecast data from ranges specified with CB.CopyData and CB.CopyDataND. This subroutine, together with CB.CopyData and CB.CopyDataND, helps you to quickly set up rows or columns of assumptions with similar distribution types or decision variables with similar bounds.
The worksheet must be active for Crystal Ball to run this command. Assumption and decision variable data can be pasted into simple value cells. or blank cells. Forecasts may be pasted only into value or formula cells.
If assumptions or decision variables are pasted into a range that is totally blank, any underlying Microsoft Excel values are pasted along with the Crystal Ball data.
If the range selected for pasting contains more value or formula cells than are selected for copying, the cells will repeat. For example, if the CopyData range includes two assumptions and the PasteData range includes three value cells, the first and second assumptions are pasted and then the first assumption is repeated.
Note: | Before calling this subroutine, copy Crystal Ball data using CB.CopyData or CB.CopyDataND. |