COPYVALUES¶

Copies the values from the given source range to the target range. 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

=COPYVALUES(SourceRange, TargetRange)

Arguments

Name Description
SourceRange Source Range to retrieve data from
TargetRange Target Range to copy values to. If Range smaller or bigger as Source Range values will be added accordingly (less input or multiple input).

Return Value

TRUE, if successful.

Example

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

COPYVALUES1


COPYVALUES2

Warning

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