Thank you I removed that line - I no longer get the error but the CPU and Memory spikes and it locks up.
Is there any other way to clear the data from memory before moving on to the next one?
Hello -
I have created a basic copy and paste macro (VBA Excel 2010) that was working fine, but when I went to expand the amount of sheets I am copying to, I started receiving an Automation Error: Object has disconnected from its client message:
I run this code over about 30 times with "Daffy...
Hello -
I have created a basic copy and paste macro that was working fine, but when I went to expand the amount of sheets I started receiving an Automation Error: Object has disconnected from its client message:
I run this code over about 30 times with "Daffy, Duck" the only thing changing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.