CB.CopyData

This subroutine stores a selected range definition for later use by CB.PasteData, which pastes all current Crystal Ball data of the selected type or types from the range stored by CB.CopyData. You can use CB.CopyData with CB.PasteData to quickly set up rows or columns of forecasts, assumptions with similar distribution types, or decision variables with similar bounds. The worksheet must be active, and the selected cell or range of cells must contain assumptions, decision variables, or forecasts.

Note:

Before calling this subroutine, select a cell or cell range containing Crystal Ball data.