View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default macro stops copying sheets into a book after the 11th sheet

This may be related to your problem (although from your description
this is not exactly what is happening).

http://www.google.com/groups?selm=03...&output=gplain

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I have a Workbook that contains 40 (varies) sheets. I copy 8 rows of
data onto a (graph) sheet, then rename it and move it to a final
workbook. after the 11th or 12th sheet my final book will not accept
any sheets. I tried manually and it will not accept a sheet.
I was getting error 91 messages in a previous portion of my macro when
looking for specific columns and deleting them so I used "on error
resume next", Thus I am not getting any messages.

Why won't my book accept more than 11 sheets with only 8 rows of data
and 8 simple line charts?
Any ideas would be appreciated,
Mitch