Dear Experts,
It there any Formula to count worksheets in a Excel File. I know VBA code
for this but i want any Formula or any combination of formula's only to
solve this. kindly Help. This is very critical for me.
Thanks in Advance..
--
Pankaj Pandey
Bhopal
--
FORUM RULES (934+ members
@googlegroups.com
Cc: pankaj.pandey
Subject: $$Excel-Macros$$ Expert Advice Needed - Formula to count Worksheets
Dear Experts,
It there any Formula to count worksheets in a Excel File. I know VBA code for
this but i want any Formula or any combination of formula's only to solve this.
kindly
Dear Pankaj,
Please find attached sheet i hope it will help to you.
Press F2 in Formula for Refresh..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue,
Create a Name in your workbook (ribbon Tab Formula Name Manager
Name (for Excample) : SheetsCount
Refer to: =GET.WORKBOOK(4)
[image: Create a NAME.PNG]
in the sheet you can use
*=SheetsCount*
resultling number of sheet in the workbook
they called it : Macro Excel4