SHEETS (PQL - xl)

This function returns the number of sheets in a reference

  • Library: PQL \ Spreadsheet \ Information
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

SHEETS(reference)

Function Arguments

Name

Description

Type

Optional

reference

Reference is a reference for which you want to know the number of sheets it contains. If the reference is omitted, the function returns the number of sheets in the workbook that contains the function

String

Comments

This function is the same as the Microsoft Excel 'SHEETS' function - using the same inputs, logic and outputs.