# MONTE.RANGE function

## Description

Return rows of a range during a simulation.

## Syntax

MONTE.RANGE(range, _cyclic)

 range is a a 2-dimensional range of cells. _cyclic is an optional boolean indicating cycling over rows.

Return the n-th row of a range on iteration n.

MONTE.RANGE allows for data driven simulations. By default a simulation stops when the last row is returned. If _cyclic is TRUE then simulation continues starting from the first row. MONTE.RANGE returns the same number of rows as the output range.