Copy method (Excel Graph)
The Copy method as it applies to the ChartArea and Range objects.
Copies a picture of the point or series to the Clipboard.
expression.Copy
expression Required. An expression that returns a ChartArea object.
Copies the range to the specified range or to the Clipboard.
expression.Copy (Destination)
expression Required. An expression that returns a Range object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Destination | Optional | Variant | Specifies the new range to which the specified range will be copied. If this argument is omitted, Graph copies the range to the Clipboard. |
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")
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.