Hi Ezzy,
First I would like to know why you have assigned the variable ThisWorkbookName to ActiveWorkbook.Name and then in the 3rd line you don't use that variable?
In my opinion this looks kinda redundant since ThisWorkbook.Worksheets("1) Intro").Copy and ActiveWorkbook.Worksheets("1) Intro").Copy is the same thing.
This part of the code would do just fine. Try and see by removing the 1st line of code and leaving just the 2.
Another thing you could do is use this line of code but BE CAREFUL since you don't want to ignore something that could affect your output. This code is good to ignore errors but don't assume that ignoring errors is a good thing.
Thanks,
Fonzie
Bookmarks