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.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5    Statistic  


Gets the named range coordinates by index.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes
MBS( "XL.Sheet.NamedRange"; bookRef; sheetIndex; Index; selector { ; ScopeID } )   More


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
Index The index of the named range from 0 to XL.Sheet.NamedRangeCount. 0
selector What information to return: rowFirst, rowLast, colFirst, colLast and name. "name"
ScopeID Optional
The scope ID to use for search.
Can be -2 for undefined, -1 for workbook or positive number for other IDs.
Default is undefined.


Returns value or error.


Gets the named range coordinates by index.

See also

Created 18th August 2014, last changed 16th March 2018

XL.Sheet.MergeSize   -   XL.Sheet.NamedRangeCount

Feedback: Report problem or ask question.

MBS FileMaker Plugins