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.