| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of worksheets in a Excel 2007
Dear Sir,
I am using MS office 2007, and want to know what is command/formula to count the number of worksheets in a Excel. I deals with some taxation matter wherein I need to have hundreds of sheets in a file. Thank in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting number of worksheets in a Excel 2007
From within Excel code, Worksheets.Count will return the number of
worksheets in the workbook. -- Rick (MVP - Excel) "Y D" <Y wrote in message ... Dear Sir, I am using MS office 2007, and want to know what is command/formula to count the number of worksheets in a Excel. I deals with some taxation matter wherein I need to have hundreds of sheets in a file. Thank in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manage a high number of worksheets in one workbook (Excel 2007) | Excel Discussion (Misc queries) | |||
| Excel 2007 counting numbers | New Users to Excel | |||
| Counting Number of Occurrences in worksheets | Excel Discussion (Misc queries) | |||
| Number of rows in Excel 2007 worksheets | Excel Discussion (Misc queries) | |||
| Counting the number of Worksheets in a Workbook | Excel Worksheet Functions | |||
Linear Mode
