Number of Sheets in a workbook formula

  • Thread starter Thread starter PCLIVE
  • Start date Start date
P

PCLIVE

Is there a formula that will return the number of sheets in a workbook?

Thanks.
 
One way is to put this function in a standard module, then in any cell of
any sheet type "=NumShts()" without the quotes. HTH Otto
Function NumShts()
NumShts = Sheets.Count
End Function
 
Thanks Otto,

I already knew this way, but I was trying to avoid vba for this workbook.

Anyway, it's been awhile since I posted this question (awhile today). I
found another way to do what I needed.
Thanks anyway.
 
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

Excel Formula - Count Dates from another Sheet 8
Match and Vlookup issue 2
Sheet selected, automatic return to top of sheet 7
move worksheet to end of another workbook 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Formula Based on Multiple Sheets 5
Excel Drag autofill only part of formula 3
retrieve data from different workbook 1

Back
Top