How many total worksheets (tabs) can you have in one workbook? Thanks
As many as the memory can handle if you add them via VBA.
(there is no email, no snail mail, but somewhere should be gmail in my addy)
in xl help type the word specifications. this will tell you the specs and
limits of your version of excel.
2007 specs and limits.
number of sheets in a workbook.....limited by available resources.
Lots. It depends on how much your pc's memory can handle.
How many do you want?
While researching the answer to this question I stumbled on this MS
It lists the specs and limits for charts, worksheets, etc, for XL
- Hide quoted text -
The maximum default number in a new workbook is 255.
After that you can add as many as you like depending upon resources as others
Gord Dibben MS Excel MVP