Getting a "RUNTIME ERROR 1004" "Method 'Worksheets' of object '_Global' failed" error that I'm not sure how to resolve?
It occurs early in the code at this point (highlights this line in yellow)
SCENARIO:
The workbook arrives with a single sheet called "Sheet1" (this is a report that has a lot of garbage that the code will clean up)
The code first preserves that original report by:
1- creating a duplicate copy of it
2- renaming one of those sheets "Original Rpt"
3- places the new sheet to the left of that "Original Rpt" (preserved sheet)
Here's a snippet from the beginning of the code:
Hoping someone sees what's wrong?
Thank you
Bookmarks