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
Event	Specifies the event on which to read thespecified Value. This parameter must be a reference to one of the following: The Image data structure in cell A0, containing the AcquireImage function. For more information, see AcquireImage. A cell containing an Event function. For more information, see Event. A cell containing a Button function. For more information, see Button. A cell containing a numeric value, and if the numeric value changes, an event will be triggered.
Iterations to Repeat	Specifies the number of iterations (0 to 5000) that should be repeated.
Cells to Repeat	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.

Parameter

Description

Event

Specifies the event on which to read thespecified Value. This parameter must be a reference to one of the following:

The Image data structure in cell A0, containing the AcquireImage function. For more information, see AcquireImage.
A cell containing an Event function. For more information, see Event.
A cell containing a Button function. For more information, see Button.

A cell containing a numeric value, and if the numeric value changes, an event will be triggered.

Iterations to Repeat

Specifies the number of iterations (0 to 5000) that should be repeated.

Cells to Repeat

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.