Excel Crashes on Copy Worksheet Before:Sheet(1)

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Hi,

I have a coplex worksheet that usesd to have about 50
sheets. I had this problem a long tme ago, and couldn't
solve it so I used to Hide unused sheets and Unhide when
necesary. This can be done manually or by a Macro. THis
works fine.

I'm trying now to fix the proble, so I deleted all the
sheets, and tried to copy sheet many times.

If I manually Copy Worksheet Before:Seheet(1) three times,
on the third time Excel crashes withour fail.

If I use a macro I get warious errors:

First -
Runtime Error '-2147417848 (80010108)':
Automaqtic Error
The object invoked has disconnected from its client.

Next I invoke Err Reporting -
Error # 91 was generated by VBAPZroject
Object varible or With block variable not set

If I invoke If Error Resume Next -
The next copy fails with ZRuntime Error '9':
Subscript out of range

If I then try a manual Copy -
Runtime Error '-2147417848 (80010108)':
Automaqtic Error
The object invoked has disconnected from its client.


Any hints graqtefully received.

Don
 
Back
Top