Range.Copy Method

  • Article
Excel Developer Reference

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

Syntax

expression.Copy(Destination)

expression   A variable that represents 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, 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")

See Also