MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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