Copy Method
Copy method as it applies to the ChartArea object.
Copies a picture of the point or series to the Clipboard.
expression.Copy
expression Required. An expression that returns one of the above objects.
Copy method as it applies to the Range object.
Copies the Range to the specified range or to the Clipboard.
expression.Copy(Destination)
expression Required. An expression that returns one of the above objects.
Destination Optional Variant. Specifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Graph copies the range to the Clipboard.
Example
This example copies the formulas in cells A1:D4 on the datasheet into cells E5:H8.
Set mySheet = myChart.Application.DataSheet
mySheet.Range("A1:D4").Copy _
Destination:= mySheet.Range("E5")