Skip to content

Instantly share code, notes, and snippets.

@laxman954

laxman954/no_of_Sheets_Excel

Created September 12, 2014 07:07
Show Gist options
  • Save laxman954/c9d26b52104cb7594c60 to your computer and use it in GitHub Desktop.
Save laxman954/c9d26b52104cb7594c60 to your computer and use it in GitHub Desktop.
Download ZIP
Find number of sheets in Excel
Raw
no_of_Sheets_Excel
1. Click 'Ctrl+F3', then 'Name Manager' Box Appears
2. Click 'New' (use shortcut key Alt+N)
3. Then, 'New name' box appears
4. Enter 'Name' as "CountSheets"(Your choice)
5. Enter 'Refer To' as =GET.WORKBOOK(1)&T(NOW())
6. Click OK
7. It takes you to the 'Name Manager' box again (you can find the Defined Name in the list)
8. Click 'Close'
9. Come to the Cell, where you want to enter the Formula
10. Enter the Formula as =COUNTA(INDEX(CountSheets,0))
11. Click Enter
Ref: http://goo.gl/UNAFY3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment