Copies the specified range to another range or to the Clipboard.
Syntax
expression.Copy(RangeDest)
expression An expression that returns a Range object.
RangeDest Optional Variant. If you do not specify this argument, the source range is copied to the Clipboard. If this argument is a Range object, the source range is copied to the specified range.