VALUE.SWAP
Copies the values from the given source range to the target range and vice versa. Beware that only the values are copied and not formulas. If the target range is a multiple of the source range, the target range is filled repeatedly with the source values.
Syntax
=VALUE.SWAP(Range1, Range2)
Arguments
| Name | Type | Description |
|---|---|---|
| Range1 | Range | Range to exchange |
| Range2 | Range | Range to exchange |
Return
| Type | Description |
|---|---|
| Boolean | TRUE, if successful. |
Examples
| |A|B| ||---|---|---| |1| | | |2|Element1a|Element2a| |3| | | |4|Element1b|Element2b|
| Formula | Result | Comment |
|---|---|---|
| TRUE | Values in A2:B2 will be swapped with VALUES in A4:B4 |
danger
Only the values will be moved. Formulas will be removed.