| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook property telling number of sheets
Gentlemen and ladies,
Does anyone know of a way to obtain in VB the number of sheets that exist in a given workbook? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook property telling number of sheets
One way:
nNumSheets = Workbooks("Workbook1.xls").Worksheets.Count In article .com, wrote: Does anyone know of a way to obtain in VB the number of sheets that exist in a given workbook? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook property telling number of sheets
Michael, use Sheets.Count something like this
Sub sheetcount() MsgBox "There Are " & Sheets.Count & " Sheet(s) in this workbook" End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 wrote in message oups.com... Gentlemen and ladies, Does anyone know of a way to obtain in VB the number of sheets that exist in a given workbook? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook property telling number of sheets
Excellent. I am very grateful for your expertise.
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook property telling number of sheets
Excellent. I am very grateful for your expertise.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Sheets in a workbook formula | Excel Worksheet Functions | |||
| max number of sheets possible in a workbook? | Excel Discussion (Misc queries) | |||
| Open workbook with x number of sheets | Excel Programming | |||
| Limit on number of Sheets in a Workbook? | Excel Programming | |||
| Return the number of Sheets in a Workbook | Excel Programming | |||
Linear Mode
