# SpreadsheetSetCellRangeValue

Sets the same value to a range of cells.

## Method Signature

```
SpreadsheetSetCellRangeValue(spreadsheetObj=[any], value=[any], startRow=[any], endRow=[any], startColumn=[any], endColumn=[any])
```

### Arguments

| Argument         | Type      | Required | Description                                  | Default |
| ---------------- | --------- | -------- | -------------------------------------------- | ------- |
| `spreadsheetObj` | `ANY`     | `true`   | The spreadsheet object.                      |         |
| `value`          | `ANY`     | `true`   | The value to set for all cells in the range. |         |
| `startRow`       | `NUMERIC` | `true`   | The starting row number (1-based).           |         |
| `endRow`         | `NUMERIC` | `true`   | The ending row number (1-based).             |         |
| `startColumn`    | `NUMERIC` | `true`   | The starting column number (1-based).        |         |
| `endColumn`      | `NUMERIC` | `true`   | The ending column number (1-based).          |         |

## Examples

Set value for a range of cells:

```js
// Fill range with value
var spreadsheet = SpreadsheetNew();
SpreadsheetSetCellRangeValue( spreadsheet, "Sample", 1, 1, 3, 3 );
```

## Related

* [SpreadsheetSetCellValue()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetcellvalue) - Set single cell
* [SpreadsheetClearCellRange()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetclearcellrange) - Clear range