Hello.
I've written a code to create a duplicate of a pre-made sheet into the same workbook. It worked for a while but now it's giving me runtime error 1004 saying that "Copy method of Worksheet class failed". I'm not sure how to remedy this.
My code is this:
Please Login or Register to view this content.
Last edited by russwongg; 02-03-2017 at 02:42 AM. Reason: Solved
.
Your macro works here.
Sometimes a workbook can get corrupted (for no good reason).
Simple remedy is to type the macro into a new workbook and start fresh.
If that is not an option, there are VBA macros and freeware online you might try to repair your workbook.
You could search for " excel repair corrupted workbook "
Thanks! This works. I never knew it could get corrupted like that.
Wonderful !
Thanks for the Add Rep
Last edited by Logit; 02-03-2017 at 01:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks