how many worksheets it has in MS Excel?

  • Thread starter Thread starter canadian
  • Start date Start date
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()
 
Hi,

If you type "specifications" into the help file wizard
you will find all of Excel's limitations for your version.

HTH
Martin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How many rows in worksheet in Excel 97? 2
How to work with Many Worksheets 3
Editing an "IF" function across a worksheet/excel file 2
MS Excel 2003 - Worksheets on viewable 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I determine how many worksheets a workbook has at a glance 3
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
can excel add worksheets based on cell population in another works 3

Back
Top