Copy Method
Applies To
ChartArea object, Range object.
Description
Syntax 1: Copies the object to the Clipboard. Copies a picture of the point or series to the Clipboard.
Syntax 2: Copies the Range to the specified range or to the Clipboard.
Syntax 1
expression.Copy
Syntax 2
expression.Copy(Destination)
expression Required. An expression that returns an object in the Applies To list.
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.
See Also
Paste method.
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")