Copy Method

  • Article

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")

Applies to | ChartArea Object | Range Object

See Also | Paste Method