Getting Strange Automation Error in Copying the data

Hi all,

I have a sheet, single sheet in a workbook, with average size of data in it. When I select all the cells, and copy it manually, then its hangs for a fraction of second and copies the data to clipboard. However, when I use the following code:

Activesheet.cells.copy or after setting the range and say rng.copy...any command/type I use to copy the used range...its giving me error!!!

The actually error, I am getting is :

Run-Time Error '-2147417848 (80010108):

Automation Error
The object invoked has disconnected from its clients.

Please note, that I have removed every code from it, and I am not using any activex in my vba for time being. So I dont really understand why is it occurring? I cannot share the template bcoz its a bussiness template which I cannot share at all. Can you please let me know that what can be the possible reasons for this issue?

Originally Posted by shg

You might search MSDN -- there are several hits, including some related to the use of early binding.

Hi,

I have done it already.. And you say about Early Binding, but I am not using any codes so no question arises of Enum bug which MSDN suggests. Also, I have found the actual Bug in the sheet. There were some incorrect name ranges defined, which were pointing nowhere and hence not letting the code to copy the material. I really don't know how name ranges can effect the copying through the code, but yes, this is the only and only reason for that error...

Any thoughts????

Originally Posted by shg

It's fixed, right? No, I have no further thoughts.

Yeh, it is!!! Thanks for your help