VALUE.COPY
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
=VALUE.COPY(SourceRange, TargetRange)
Arguments
| Name | Type | Description |
|---|---|---|
| SourceRange | Range | Source Range to retrieve data from |
| TargetRange | Range | 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
| Type | Description |
|---|---|
| Boolean or Error | TRUE, if successful. |
Examples
| |A|B| ||---|---|---| |1| | | |2|Element1a|Element2a| |3| | | |4|Element1a|Element2a|
| Formula | Result | Comment |
|---|---|---|
| TRUE |
danger
Only the values will be moved. Formulas will be removed.