Ok, I thought this would be simple but it has me stumped.
I have a workbook with many (up to a hundred or more) worksheets generated by a large macro.
I have two in the front and two and the end I want to keep - the rest I want to delete.
Thought it would be a simple loop, but it keeps giving me a Subscript out of range error around loop 9. The actual worksheet order in VBA varies from Sheet1 to Sheet 30 or more, and the order is scrambled.
Anyone see anything obvious?Please Login or Register to view this content.
Thanks.
Bookmarks