Monkeybread Software - MBS FileMaker Plugin: XL.Sheet.SetActiveCell

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 12.2 12.3 12.4 12.5 13.0 13.1 13.2 13.3 13.4 13.5 Statistic FMM Blog

XL.Sheet.SetActiveCell

Sets an active cell of the sheet.

Component	Version	macOS	Windows	Linux	Server	iOS SDK
XL	13.1	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MBS( "XL.Sheet.SetActiveCell"; bookRef; sheetIndex; Row; Column ) More

Parameters

Parameter Description Example

bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref

sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0

Row The row for the cell. First row has index 0. $row

Column The column for the cell. First column has index 0. $column

Parameter	Description	Example
bookRef	The reference to the workbook. Please use XL.LoadBook to load a file.	$ref
sheetIndex	The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1.	0
Row	The row for the cell. First row has index 0.	$row
Column	The column for the cell. First column has index 0.	$column

Result

Returns OK or error.

Description

Sets an active cell of the sheet.

Release notes

Version 13.1
- Added XL.Sheet.AddSelectionRange, XL.Sheet.GetActiveCell, XL.Sheet.RemoveSelection, XL.Sheet.SelectionRange and XL.Sheet.SetActiveCell functions.

Blog Entries

Created 3th February 2023, last changed 3th February 2023

XL.Sheet.SelectionRange - XL.Sheet.SetAutoFitArea