VALUE.MOVE
Move values in source range to target range.
Syntax
=VALUE.MOVE(SourceRange, TargetRange)
Arguments
| Name | Type | Description |
|---|---|---|
| SourceRange | Range | Range to get values to move from. |
| TargetRange | Range | Range to move values to. Smaller Target Range leads to the removal of all Source Values, but not in the writing of all. Bigger does not have any further consequences. |
Return
| Type | Description |
|---|---|
| Boolean or Error | TRUE, if no error. |
Examples
| |A|B| ||---|---|---| |1| | | |2|Element1a|Element2a| |3| | | |4| | |
| Formula | Result | Comment |
|---|---|---|
| TRUE | Values on A2:B2 will be moved to A4:B4 |
danger
Only the values will be moved. Formulas will be removed.