Skip to main content
Version: Streamsheets 3.0

VALUE.MOVE

Move values in source range to target range.

Syntax

=VALUE.MOVE(SourceRange, TargetRange)

Arguments

NameTypeDescription
SourceRangeRangeRange to get values to move from.
TargetRangeRangeRange 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

TypeDescription
Boolean or ErrorTRUE, if no error.

Examples

| |A|B| ||---|---|---| |1| | | |2|Element1a|Element2a| |3| | | |4| | |

FormulaResultComment
=VALUE.MOVE(A2:B2,A4:B4)
TRUEValues on A2:B2 will be moved to A4:B4
danger

Only the values will be moved. Formulas will be removed.