Edit

Copy method (Excel Graph)

  • Article

The Copy method as it applies to the ChartArea and Range objects.

ChartArea object

Copies a picture of the point or series to the Clipboard.

Syntax

expression.Copy

expression Required. An expression that returns a ChartArea object.

Range object

Copies the range to the specified range or to the Clipboard.

Syntax

expression.Copy (Destination)

expression Required. An expression that returns a Range object.

Parameters

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.

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

Support and feedback

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.