View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Problem with creating Worksheets with Macros

I have a macro that depending on the options created by the user will create
additional worksheets. Up to 70 worksheets could be needed in the file. The
marco will only create 62 worksheets. It crashes when it attempts to create
the 63 worksheet. After it crashes I cannot manually add any worksheets to
the file. Nothing happens when I try to insert or copy a worksheet.