| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
total no of worksheets in the workbook
Hi
i am trying to find out the total no of worksheets in the workbook...i have in total 4 worksheets... but somehow its giving me incorrect value of 9...the total count instaead of 4 is comign to be 9........ what could be the reason.. here is how i am getting it: cntB = Workbooks(uuWkBkName).Worksheets.Count cntB = ActiveWorkbook.Worksheets.Count i have used this before and was never a problem..only today its giving me this absurd error! thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto copy total from one workbook to another workbook | Excel Worksheet Functions | |||
| How many total worksheets can be added to a workbook? | Excel Discussion (Misc queries) | |||
| Sum total from other worksheets | Excel Worksheet Functions | |||
| how do I get a total for all worksheets in my workbook? | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Threaded Mode
