Skip to content
REFERENCE

U.VREPEAT

Summary

Repeats the specified rows/columns the specified number of times

Syntax

=U.VREPEAT(data, num_repeats, [label_depth], [num_spaces])

Parameters

Parameter Required Description
data Yes The data whose rows/columns will be repeated
num_repeats Yes The number of times to repeat the specified data
[label_depth] No The number of labels in the data (labels not repeated) Default is 0 if not specified
[num_spaces] No The number of blank rows/columns to insert between each repeat. Default is 0 if not specified

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.VREPEAT(B4:C6,1)

=U.VREPEAT(B13:C16,1,1)

=U.VREPEAT(B13:C16,2,1,2)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.