This function returns the sheet number of the reference sheet.

Syntax

SHEET(value)

Arguments

For the argument, the name of a sheet or a reference for which you want the sheet number. This argument is optional.

Remarks

The #REF! error value is returned if the value argument is an invalid value. The #NA error value is returned if the value argument is an invalid sheet name.

Data Types

Accepts string data. Returns numeric data.

Examples

SHEET(Products) gives the result 1, where Products is the name of the first sheet(Sheet1) in the workbook.

SHEET("SheetFour") gives the result 4, where SheetFour is the name of the 4th sheet in the workbook.

Version Available

This function is available in Spread for Windows Forms 11.0 or later.