Limit to copying sheets??

N

Nate Kolman

Is there a limit to the number of times a worksheet can be copied??
I'm working in Excel 2000.

I have a workbook set up with one of the sheets named "Report". The
macro I wrote pulls filtered data from another sheet and fills it into
the report sheet. Then it does a PrintPreview and then restores
everything back to the way it was. The way I have it set up is that
the "Report" sheet is copied creating "Report (2)" to save all hard
cells and formatting. Then after the printpreview, the "Report" sheet
is deleted and I rename the "Report (2)" to "Report" thus creating the
illusion that nothing changed.

After running this macro several times (200+) I am now getting an
error that the copy method on the sheets is not working. When I exit
out of the VBE, to the normal Excel sheet and try manually copying the
sheet, that won't work either. Have I exceeded some magical limit?
Or is there some other way that I can give this 'illusion'??

Thanks in advance,

Nate Kolman
 
N

Norman Jones

Hi Nate,

I believe that the determining factor is the number of copy operations
rather than the number of sheets.

See the following recent conversation with Rob Bovey:

http://tinyurl.com/4swma

Regards,
Norman
 
Top