WORKSHEETCOUNT

Counts the number of worksheets in the current workbook. You can specify (through an optional argument) whether you want to count only the visible worksheets, only the hidden worksheets, or both.

Syntax

WORKSHEETCOUNT(visibility)

visibility Optional. An integer value, either 0, 1, 2 or 3. Default value is 0.
0 means ALL 1 means True only
2 means False only
3 means xlVeryHidden only