I am having a problem with the create new worksheet code. Every time I create a new worksheet, save and close, an error message "Removed Records: Object from /xl/worksheets/sheet3.xml part" appears when i reopen the file. What went wrong with my code? I did usedfor a few lines. Could this be the source of this error?![]()
On Error Resume Next
The sample provided is before creating any new worksheets. Everything is fine till a new worksheet is created, saved, closed then reopened.
Bookmarks