Repeat
Repeats the execution of specified cells for a specified number of iterations.For more information, see Create a Loop of Spreadsheet Cells.
Note: When creating a repeating iteration of cells using the Repeat or RepeatUntil functions, if using a SetEvent function, it should be placed outside the cells being iterated.Placing the SetEvent function within the cells being iterated may cause the SetEvent to miss event triggers.
RepeatInputs
Syntax: Repeat(Event,Iterations to Repeat,Cells to Repeat)
Parameter | Description |
---|---|
Specifies the event on which to read thespecified Value. This parameter must be a reference to one of the following:
|
|
Specifies the number of iterations (0 to 5000) that should be repeated. |
|
Specifies the reference to the cell or cells to be repeated.The reference must be a range of cells, a comma delimited list of cell references or a combination of the two. |
RepeatOutputs
Returns |
A Loop data structurecontaining data about the repetition of the cells. |