Export (0) Print
Expand All

Range.Copy Method

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

Syntax

expression.Copy(Destination)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
DestinationOptionalVariantSpecifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Excel copies the range to the Clipboard.

Return Value
Variant

Example

This example copies the formulas in cells A1:D4 on Sheet1 into cells E5:H8 on Sheet2.

Visual Basic for Applications
Worksheets("Sheet1").Range("A1:D4").Copy _
    destination:=Worksheets("Sheet2").Range("E5")



Community Additions

ADD
Show:
© 2014 Microsoft