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