Hi there,
I call this sub from a much larger sub to copy and name a particular worksheet. The sub works fine 9 times out of 10 but on the odd occasion I get a Automation Error with the note "The object invoked has disconnected from its client". I have done a lot of reading about this error but cannot find a solution. One solution was to edit the worksheet first to activate is hence the .clearcontents lines of code however these do not appear to be helping.
The sub:
Can anyone suggest a solution to this problem or maybe a better way to do it?Please Login or Register to view this content.
Cheers,
Marcus
Bookmarks