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

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

.

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

.