how many worksheets it has in MS Excel?

[canadian]

how many worksheets it has in MS Excel?

[j...@exceldesignsolutions.com]

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()

[MartinW]

Hi,

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

HTH
Martin

"canadian" <cana...@discussions.microsoft.com> wrote in message
news:C56222B9-7C18-4FDB...@microsoft.com...