Skip to main content
Version: 2.3

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

NameDescription
Range1Range to exchange
Range2Range to exchange

Return Value

TRUE, if successful.

Example

FunctionResultComment

TRUE<
warning

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