# ROW

#### Syntax <a href="#syntax.45" id="syntax.45"></a>

**ROW**(*range; rowIndex*)

* *range* - the range from which a row should be returned *- **Value type**: range*
* *rowIndex* - the index of the row to return *- **Value type**: integer (optional, default value: 1)*

#### Remarks <a href="#remarks.35" id="remarks.35"></a>

* If *rowIndex* is greater than the number of rows in *range* or smaller than 1, an empty row with the same amount of columns as *range* is returned.
* *rowIndex* can contain the text “last”. In this case, the last row of *range* is returned.

#### Example

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-a8f75473a1293885596b79e2fb404126f071ebee%2Fgrafik%20(479).png?alt=media" alt=""><figcaption></figcaption></figure>