Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Changed headings

...

The ranges can be one of the following forms:

1. Single slot to area

Range to copy from: a single slot, eg A1.
Range to copy to: an area, eg B3 D7, or just a row or column range. The area can include the original slot, if required.

The contents of the slot are copied over the entire area, as represented symbolically in the following diagram:

2. Column to area

Range to copy from: a column array, eg A1 A3.
Range to copy to: a single slot or a row array, eg B5 D5.

The column is copied to the target column starting at either the single slot, or the range of slots given by the target row.

3. Row to area

Range to copy from: a row array, eg A1C1.
Range to copy to: a single slot or a column array, eg B5 B7.

The row is copied to the target row, starting either at the single slot or at the range of slots given by the target column, as shown on the following page:

4. Area to area

Range to copy from: an area, eg A1 B2.
Range to copy to: a single slot, eg C5.

...