M
MISMitch
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
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