| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add worksheets
Hi
I have a workbook with about 200 worksheets The worksheets are created with a vba code and their names are based on the values of cells in columns A and B of the source worksheet Data in the source worksheet are grouped, with empty rows between the groups I am trying to find a way to add a worksheet in the same order as new data is entered in the source worksheet Thanks for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add worksheets
Try the Add Method under the Worksheets Collection in
Help. One word of warning, I believe Excel has a limit on the number of worksheets that can be placed into a workbook. One of the more experinced people in this forum can tell you what that limit is. Just something to take into account. -----Original Message----- Hi I have a workbook with about 200 worksheets The worksheets are created with a vba code and their names are based on the values of cells in columns A and B of the source worksheet Data in the source worksheet are grouped, with empty rows between the groups I am trying to find a way to add a worksheet in the same order as new data is entered in the source worksheet Thanks for your help . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add worksheets
The limit is memory Kevin
-- Regards Ron de Bruin http://www.rondebruin.nl "Kevin" wrote in message ... Try the Add Method under the Worksheets Collection in Help. One word of warning, I believe Excel has a limit on the number of worksheets that can be placed into a workbook. One of the more experinced people in this forum can tell you what that limit is. Just something to take into account. -----Original Message----- Hi I have a workbook with about 200 worksheets The worksheets are created with a vba code and their names are based on the values of cells in columns A and B of the source worksheet Data in the source worksheet are grouped, with empty rows between the groups I am trying to find a way to add a worksheet in the same order as new data is entered in the source worksheet Thanks for your help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
| How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| Sort Numerically Worksheets via VB when creating a new worksheets | Excel Programming | |||
| Need code to protect worksheets - amount of worksheets varies | Excel Programming | |||
Linear Mode
