I have a fine that I have been using since 2007. Yesterday we converted to Office 2010 and now some macros are not working. I get the following error:
Run-time error '-2147417848 (8001010)':
Automation error
The object invoked has disconnected from its clients.
When I debug is breaks here (the red text is highlighted):
ws.rows("2:2").Copy
ws.rows("3:3").Insert shift:=xlDown
ws.rows("3:3").EntireRow.Hidden = False
I have searched and searched and can find nothing helpful. This code runs fine in both Excel 2003 and 2007 but blows up in 2010.
Please help I think I'm going crazy!
Run-time error '-2147417848 (8001010)':
Automation error
The object invoked has disconnected from its clients.
When I debug is breaks here (the red text is highlighted):
ws.rows("2:2").Copy
ws.rows("3:3").Insert shift:=xlDown
ws.rows("3:3").EntireRow.Hidden = False
I have searched and searched and can find nothing helpful. This code runs fine in both Excel 2003 and 2007 but blows up in 2010.
Please help I think I'm going crazy!