When I run a VBA macro to copy a sheet in a project, I receive the following error message:
Run-time error '-2147417848 (80010108)':
Automation error
The error occur on the following code:
Worksheets("Plan T").Copy After:=Sheets(Sheets.Count)
In fact I have run this code for more than 300 times, but after the first error occur, this funtion didn't run again.
And Now I use Excel 2003.
How do I solve this problem?
Bookmarks