Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Cannot move/copy sheets "to the end"

Posted by Michael Doxsee on October 10, 2000 3:24 PM

Hi,

I have quite a large excel workbook with several sheets that get copied to the end of the workbook every week. All of a sudden this does not work with all the sheets anymore. There is ONE sheet that I can copy, but that's it. The copy of that sheet, however, can't be copied anymore.
Does anyone have an idea what might cause that?

Thanks alot for you help!
Michael

Re: Cannot move/copy sheets "to the end"

Posted by Ivan Moala on October 11, 2000 4:23 AM

Micheal
These may be able to help and explain what is happening

XL97: Cannot Move or Copy Sheet After Last Sheet
http://support.microsoft.com/support/kb/articles/Q143/4/58.asp?LN=EN-US&SD=gn&FR=0

Copy Method of Sheets Object Causes Invalid Page Fault
http://support.microsoft.com/support/kb/articles/Q177/6/34.ASP?LN=EN-US&SD=gn&FR=0

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.