MOVEVALUES¶

Move values in source range to target range.

Syntax

=MOVEVALUES(SourceRange, TargetRange)

Arguments

Name Description
SourceRange Range to get values to move from.
TargetRange 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 Value

TRUE, if no error.

Example

Function Result
=MOVEVALUES(A2:B2,A4:B4)

MOVEVALUES1
After MOVEVALUES

MOVEVALUES2

Warning

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