Spread Formula Reference
Formula Functions / Functions R to S / SHEETS
In This Topic
    SHEETS
    In This Topic

    This function returns the number of sheets in a reference.

    Syntax

    SHEETS(ref)

    Arguments

    For the argument, the reference for which you want to know the number of sheets. This argument is optional.

    Remarks

    The #REF! error value is returned if the reference is not a valid value. The total number of sheets in the workbook is returned if no parameter is listed.

    Data Types

    Accepts string data. Returns numeric data.

    Examples

    SHEETS(Products) gives the result 2.

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.