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 | Comment |
---|---|---|
=COPYVALUES(A2:B2,A4:B4) | TRUE |
danger
Only the values will be moved. Formulas will be removed.