I'm wondering if this is the way things work and there's nothing to be done about it (but I doubt that).
I have a workbook that I load data into from a csv file. The csv file is "divided" into regions, and I want each region's group of data to be loaded into a separate sheet. To be on the safe side, I delete all the sheets before loading the data with the following code that I found in this forum
Then, for each new region, I create a new sheet with the following code
Trouble (?) is, what Im'seeing is that even though the code seems to be working inasmuch as I get my new sheets for each region, each time I run the code, the sheet numbers in my VBA project are being incremented. For example, assuming 4 regions, then the very first time, I get something like
The next time I run it, I get
Does this matter ? Can I "correct" it to restart at Sheet1 ?