XL.Book.SheetIndexForName
-------------------------

Queries sheet index for sheet name.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [5.4](newinversion54.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Book.SheetIndexForName"; BookRef; Name ) 

**MBS**( **"XL.Book.SheetIndexForName";** /\* Queries sheet index for sheet name. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$Name**) /\* The name of the sheet to keep.e.g. "People" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| Name | The name of the sheet to keep. | "People" |

### Result

Returns number or error.

### Description

Queries sheet index for sheet name.  
Returns empty result if not found.  
### Examples

Shows index for a sheet:

 Show Custom Dialog \["Sheets"; MBS ("XL.Book.SheetIndexForName"; $bookRef ; "Reiter 2")\]  
### Blog Entries

- [LibXL for FileMaker with extras](https://www.mbsplugins.de/archive/2021-03-02/LibXL_for_FileMaker_with_extra/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 5.4pr5](https://www.mbsplugins.de/archive/2015-11-10/MBS_FileMaker_Plugin_version_5/monkeybreadsoftware_blog_filemaker)

### FileMaker Magazin

- [Ausgabe 5/2022, Seite 22](https://filemaker-magazin.de/neuigkeit/4196-Appetithappen-FMM_202205)

This function checks for a license.

Created 4th November 2015 , last changed 4th November 2015

  
[XL.Book.SheetCount](XLBookSheetCount.md) - [XL.Book.SheetName](XLBookSheetName.md)

[HTML Version](XLBookSheetIndexForName.shtml)