SWAPVALUESΒΆ

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

=SWAPVALUES(SourceRange, TargetRange)

Arguments

Name

Description

Range1

Range to exchange

Range2

Range to exchange

Return Value

TRUE, if successful.

Example

Function

Result

=SWAPVALUES(A2:B2,A4:B4)

SWAPVALUES1
After call of SWAPVALUES

SWAPVALUES2

Warning

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