# xlsMakeRange¶

## Purpose¶

Builds an Excel® range string from a row/column pair.

## Format¶

range = xlsMakeRange(row, col)
Parameters: row (scalar or 2x1 vector) – row(s) col (scalar or 2x1 vector) – column(s) range (string) – an Excel®-formatted range specifier.

## Examples¶

### Example 1: Create a single cell index¶

// Scalar inputs
r = 3;
c = 6;

range = xlsMakeRange(r, c);
print range;


produces:

F3


### Example 2: Create a cell range string¶

// 2x1 vector inputs
r = { 2, 37 };
c = { 3, 19 };

range = xlsMakeRange(r, c);
print range;


produces:

C2:S37


## Remarks¶

If row is a 2x1 vector, it is interpreted as follows

 $$row[1]$$ starting row $$row[2]$$ ending row

If col is a 2x1 vector, it is interpreted as follows:

 $$col[1]$$ starting column $$col[2]$$ ending column

If xlsMakeRange() fails, it will either terminate and print an error message or return a scalar error code, which can be decoded with scalerr, depending on the state of the trap flag.

 trap 0 Print error message and terminate program. trap 1 Return scalar error code which can be checked for with scalmiss().