I'm creating 100+ worksheets in a workbook by copying an existing sheet in that same workbook. (I've also tried copying from an external template but get the same issue). Somewhere throughout the copying I get the Copy Method Worksheet Class 1004 error and the macro craps out.
The template work around didn't work so I'm attempting to open and close the workbook every 30 copies.
Here's the catch. I am naming the worksheets based on a column of values and can't figure out how to resume copying where I left off once closing and reopening the subject file.