Count number of worksheets with no VBA

[quej2003]

HI All,

Just wondering if there is a way to count the number of worksheets in a workbook without using VBA (I know it can indeed be done there but would rather not use it). It seems so simple but I cant figure it out!

Thanks for any help!

 

[Richard Schollar]

Hi

You can use an old XLM4 macro function for this (but you can't use it directly - you need to write it into a workbook name and then refer to this):

1. Create a name and call it 'NumShts'
2. In RefersTo box type:

=GET.WORKBOOK(4)
3. Click OK and then back in the sheet, in a cell type:

=NumShts

 

[quej2003]

Hi

You can use an old XLM4 macro function for this (but you can't use it directly - you need to write it into a workbook name and then refer to this):

1. Create a name and call it 'NumShts'
2. In RefersTo box type:

=GET.WORKBOOK(4)
3. Click OK and then back in the sheet, in a cell type:

=NumShts

Thats quite awesome to say the least, thank you very much