Microsoft Office Tutorials and References
In Depth Information
Syntax
Syntax
SHEETS([3-D Reference])
SHEETS returns the number of worksheets included in a 3-D reference. For
example, if you have 12 worksheets from Jan through Dec,
=SHEETS(Apr:Jun!A1) indicates that there are three worksheets included in
the group.
Syntax
SHEET(Sheet_Name)
SHEET returns the position of the worksheet named Sheet_Name.
Syntax:
SHEET(Reference)
SHEET returns the position of the worksheet that contains reference.
Syntax
SHEET()
SHEET returns the position of the worksheet that contains the SHEET() func-
tion.
In Figure 12.14 , the workbook contains five worksheets labeled Jan, Feb,
Mar, Apr, and May. The Apr worksheet is the current worksheet. Theoretic-
ally, a new worksheet will be added for each month as data becomes avail-
able.
Search JabSto ::




Custom Search