Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4    Statistic  

XL.Sheet.SetNamedRange

Sets the named range.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes

MBS( "XL.Sheet.SetNamedRange"; bookRef; sheetIndex; name; rowFirst; rowLast; colFirst; colLast { ; scopeId } )

Parameters

Parameter Description Example value
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
name The name to use for the named range. "test"
rowFirst The first row for the area. First row has index 0. $row
rowLast The last row for the area. First row has index 0. $row+1
colFirst The first column for the area. First column has index 0. $column
colLast The last column for the area. First column has index 0. $column+1
scopeId Optional
The scope ID to use.
Can be -2 for undefined, -1 for workbook or positive number for other IDs.
Default is undefined.

Result

Returns OK or error.

Description

Sets the named range.

See also

Created 18th August 2014, last changed 21st April 2018


XL.Sheet.SetName   -   XL.Sheet.SetPaper

Feedback: Report problem or ask question.




Links
MBS Xojo PDF Plugins