| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum worksheets in an Excel
Hi Senthil,
try: Sub Test666() On Error GoTo ende start: ActiveWorkbook.Worksheets.Add Debug.Print ActiveWorkbook.Worksheets.Count GoTo start ende: GoTo start End Sub I stopped it at Worksheet 928. Saving took quite a while... ;-) -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA Win XP, Office 2003 "red.sys" & Chr$(64) & "t-online.de" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum worksheets in an Excel.. | Excel Programming | |||
| Maximum number of worksheets in XL | Excel Discussion (Misc queries) | |||
| maximum number of worksheets | Excel Worksheet Functions | |||
| Maximum number of worksheets in Excel 2003 | Excel Programming | |||
| Maximum value from multiple worksheets | Excel Programming | |||
![Helmut Weber[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
