add worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Excel VBA 1
Excel 2013 Merge Data 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel VBA 0
Need Macro... 8
Ron de Bruin - Merge cells from all worksheets 0

Back
Top