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
 
Back
Top