This function returns the number of sheets in a reference.

Syntax

SHEETS(ref)

Arguments

For the argument, the reference for which you want to know the number of sheets. This argument is optional.

Remarks

The #REF! error value is returned if the reference is not a valid value. The total number of sheets in the workbook is returned if no parameter is listed.

Data Types

Accepts string data. Returns numeric data.

Examples

SHEETS(Products) gives the result 2.

Version Available

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