CB.CopyDataND

Subtopics

This subroutine stores a range definition for later use by CB.PasteData, which pastes all current Crystal Ball data of the selected type from the range stored by CB.CopyDataND. You can use CB.CopyDataND 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.

This call has one parameter, DataType, described in Table 26..

Table 26. CB.CopyDataND DataType Parameter — Integer, Required

Named Constant Value

Index Value

Description

cbCelAssum

1

Copies only assumption cell data.

cbCelFore

2

Copies only forecast cell data.

cbCelDecVar

3

Copies only decision variable cell data.

Use this subroutine when the data range to copy has multiple Crystal Ball data types within the range.

This subroutine, compared to CB.CopyData, pastes only the specified data type from a range with mixed cells. If a range contains different Crystal Ball data types (assumptions, decision variables, and forecasts), then Crystal Ball will only copy the data type you specify with the DataType parameter.

Note:

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