ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counting Worksheets, Second Verse (https://www.excelbanter.com/excel-worksheet-functions/115551-counting-worksheets-second-verse.html)

Janie

Counting Worksheets, Second Verse
 
I have a user who wants to count worksheets WITHOUT using a macro/custom
function. Me, I'm a fan of Application.Worksheets.Count, but he is adamant
he does not want to go that route.

Closest I can think of is =INFO("numfile") which counts active worksheets.
Down side of this function is it also counts HIDDEN files such as
PERSONAL.XLS and any ADD-INS (like FUNCRES.XLA)

Anybody think of a formula that would allow INFO("numfile") to ignore
PERSONAL.xls or any XLA files???? Or some other solutions BESIDES the VBA
answer?

I recognize sometimes NO is the right answer. But, for anyone who can think
up a solution -- well, I'll be muy impressed!

Thanx.

Janie


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com