# SpreadsheetSetActiveSheetNumber

Sets a sheet number in a spreadsheet as active.

## Method Signature

```
SpreadsheetSetActiveSheetNumber(spreadsheetObj=[any], sheetNumber=[any])
```

### Arguments

| Argument         | Type      | Required | Description                                       | Default |
| ---------------- | --------- | -------- | ------------------------------------------------- | ------- |
| `spreadsheetObj` | `ANY`     | `true`   | The spreadsheet object.                           |         |
| `sheetNumber`    | `NUMERIC` | `true`   | The number of the sheet to make active (1-based). |         |

## Examples

Set active sheet by number:

```js
// Switch to second sheet
var spreadsheet = SpreadsheetNew();
SpreadsheetCreateSheet( spreadsheet, "Data" );
SpreadsheetSetActiveSheetNumber( spreadsheet, 2 );
```

## Related

* [SpreadsheetSetActiveSheet()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetactivesheet) - Set by name
* [SpreadsheetCreateSheet()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetcreatesheet) - Create sheet