Microsoft Office Tutorials and References
In Depth Information
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
SHEET returns the position of the worksheet named Sheet_Name.
SHEET returns the position of the worksheet that contains reference.
SHEET returns the position of the worksheet that contains the SHEET() func-
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-