sheets
Number of sheets in a workbook or reference.
Syntax
Section titled “Syntax”v = sheets(value)Description
Section titled “Description”Returns the number of sheets in value. Without arguments, returns the total number of sheets in the workbook.
Example
Section titled “Example”sheets() % total sheets in workbookSee also
Section titled “See also”sheet— Sheet number of a reference.