Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

XL.Sheet.SetNamedRange

Sets the named range.

Component Version macOS Windows Linux Server iOS SDK
XL 3.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.SetNamedRange"; bookRef; sheetIndex; name; rowFirst; rowLast; colFirst; colLast { ; scopeId } )   More

Parameters

Parameter Description Example Flags
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 The scope ID to use.
Can be -2 for undefined, -1 for workbook or positive number for other IDs.
Default is undefined.
Optional

Result

Returns OK or error.

Description

Sets the named range.

See also

Release notes

Blog Entries

This function checks for a license.

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


XL.Sheet.SetName - XL.Sheet.SetPaper