copycells

Copy a cell range, optionally to a destination range.

Syntax

copycells(crSrc)
copycells(crSrc, crDst)

Description

With one argument, copies the source range to the clipboard. With two arguments, copies directly to the destination range (without using the clipboard) — the destination is filled with the source values, formulas, and formatting.

Examples

copycells(A1:C5)                 % to clipboard
copycells(A1:C5, E1)             % directly to E1:G5

See also

• movecells — Move (cut) a cell range to a destination.
• clearcells — Clear cell contents while preserving the cells themselves.