Export (0) Print
Expand All
4 out of 11 rated this helpful - Rate this topic

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



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.