Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
count no of worksheet
is there any command to count the total no of worksheets in a file
|
#2
|
|||
|
|||
ACtiveworkbook.Worksheets.Count
-- HTH Bob Phillips "Ankur" wrote in message ... is there any command to count the total no of worksheets in a file |
#3
|
|||
|
|||
i am not able to do that can u please explain in detail......thanks for your
help "Bob Phillips" wrote: ACtiveworkbook.Worksheets.Count -- HTH Bob Phillips "Ankur" wrote in message ... is there any command to count the total no of worksheets in a file |
#4
|
|||
|
|||
This is VBA, so you need to go to the VB IDE (Alt-F11) and then either
- add it to a macro that you are writing OR - create a UDF that returns it if you want it in a worksheet function Function NumSheets() NumSheets = Application.Caller.Parent.Parent.Worksheets.Count End Function and add =NumSheets() in your worksheet -- HTH Bob Phillips "Ankur" wrote in message ... i am not able to do that can u please explain in detail......thanks for your help "Bob Phillips" wrote: ACtiveworkbook.Worksheets.Count -- HTH Bob Phillips "Ankur" wrote in message ... is there any command to count the total no of worksheets in a file |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing another worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |