| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return the number of Sheets in a Workbook
Is there a way in VB to return the number of sheets in a workbook ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return the number of Sheets in a Workbook
Yes there is:
ActiveWorkbook.Sheets.Count Regards, Jos Vens "gminor7" schreef in bericht ... Is there a way in VB to return the number of sheets in a workbook? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return the number of Sheets in a Workbook
Thanks ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return the number of Sheets in a Workbook
activeworkbook.worksheets.Count
counts just the worksheets as opposed to all sheets, and activeworkbook.charts.Count counts the number of charts -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jos Vens" wrote in message ... Yes there is: ActiveWorkbook.Sheets.Count Regards, Jos Vens "gminor7" schreef in bericht ... Is there a way in VB to return the number of sheets in a workbook? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search multiple sheets and return largest number found | Excel Worksheet Functions | |||
| How can I count number of sheets present in a workbook? | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Number of Sheets in a workbook formula | Excel Worksheet Functions | |||
| max number of sheets possible in a workbook? | Excel Discussion (Misc queries) | |||
![gminor7[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
