Limit on number of Sheets in a Workbook?
 

Is there a limit? One a macro I'm working on it will create 500 - 600 sheets in my workbook. Is this going to work in Excel or is there a limit on the number of sheets I can have?

Limit on number of Sheets in a Workbook?
 

Hi
depending on your Excel version only the memory limits the number of
sheets (see the Excel help under 'Specification). Also have a look at
http://www.decisionmodels.com/memlimits.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Mr B wrote:
Is there a limit? One a macro I'm working on it will create 500 -
600 sheets in my workbook. Is this going to work in Excel or is
there a limit on the number of sheets I can have?