Automation error
 

Hi fellow exceleites:)

I am writing a VBA moduel in excel 2003, which does certai
calculations based on data in several sheets and displays a report i
the last sheet(Tab).

I am getting this error :-

-2147417848
Automation error
The Object invoked has disconnected from its clients.

This error always occurs at the following line of code.

-ThisWorkbook.Sheets("AE Pivot").Copy Befo=NewBook.Sheets(1)-

After i click OK on error msg box, excel seems to get bugged up an
shuts down itself and launches itself again with a new blank workshee
:confused:

And as if this wasnt enough this error doesnt occur evrytime, its quit
moody,
occurs say once in 10-12 runs, but always on the same line of code.
Plzzzz help:mad

--
karanbhati
-----------------------------------------------------------------------
karanbhatia's Profile: http://www.excelforum.com/member.php...fo&userid=3427
View this thread: http://www.excelforum.com/showthread.php?threadid=54034