Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting data over multiple worksheets | Excel Worksheet Functions | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Duplicate Worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Help with counting across worksheets | Excel Discussion (Misc queries) |