This example prompts you to select which data to copy — either the assumption or forecast data. It then copies only the selected data within the selected range.
'Range selected in the following line contains an assumption and a forecast Range ("B5:C7").Select 'contains an assumption and a forecast CB.CopyData