Is there a formula that will return the number of sheets in a workbook? Thanks.
P PCLIVE Jun 22, 2006 #1 Is there a formula that will return the number of sheets in a workbook? Thanks.
O Otto Moehrbach Jun 22, 2006 #2 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
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
P PCLIVE Jun 22, 2006 #3 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.
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.
