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?
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
