movetable

Move a table or variable cell block to a new position.

Syntax

movetable(src_rg, tgt_rg)

Description

Moves the cell block (data table or variable-cell-block) anchored at the source range to the target range. The cell block’s data, formatting, and layout move as a unit. Different from movecells, which works on free-floating cell ranges; movetable works on managed cell-block objects.

Example

movetable(A1:C10, F1:H10)

See also

• movecells — Move (cut) a cell range to a destination.
• resize — Resize a variable cell block.
• expand — Expand a previously collapsed cell block.
• collapse — Collapse a cell block to its summary view.