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.