Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how many worksheets it has in MS Excel?
how many worksheets it has in MS Excel?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how many worksheets it has in MS Excel?
Hi there
Do you mean: 1. How many worksheet can you have in a workbook? (A) There is no fixed limit by number, but you are limited by the memory on your machine. 2. How many worksheets are in a specific workbook? (A) You could use a macro to count this, a user defined function perhaps. Something like: Function SheetsCount() SheetsCount = ThisWorkbook.Sheets.Count End Function You could apply this in a range in a sheet as follows: =SheetsCount() |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how many worksheets it has in MS Excel?
Hi,
If you type "specifications" into the help file wizard you will find all of Excel's limitations for your version. HTH Martin "canadian" wrote in message ... how many worksheets it has in MS Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |