SHEETS

SHEETS(arg1) → { number | string | boolean }

Returns the number of sheets in a reference.

Parameters:

Name Type Description
arg1 ApiRange

Is a reference for which you want to know the number of sheets it contains. If omitted the number of sheets in the workbook containing the function is returned.

Returns:

Type
number | string | boolean