Is there a way to renumber the worksheets in a workbook?
I have some code that deletes worksheets so it can add new data. I'd like to reorder the worksheet indexes to be 0,1 and 2 so that when it creates a new worksheet in code it is called Sheet4 instead of SHeet 13 or SHeet106 depending on how many times the macro is run