Skip to content

sheets

Number of sheets in a workbook or reference.

v = sheets(value)

Returns the number of sheets in value. Without arguments, returns the total number of sheets in the workbook.

sheets() % total sheets in workbook
  • sheet — Sheet number of a reference.