Skip to main content
Version: Streamsheets 2.4

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

NameDescription
SourceRangeSource Range to retrieve data from
TargetRangeTarget 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

FunctionResultComment
=COPYVALUES(A2:B2,A4:B4)
TRUE
warning

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