How to make the sheet index name same as the sheet name after inserting sheets?
When a new worksheet is added to a workbook then Sheet4 takes the
Sheet3's index name and becomes Sheet3(Sheet4) and so on. I am
referencing the new worksheets using Sheets(i).Select. I want Sheet4
to be selected but inserting worksheets makes Sheet3 as Sheet4. So, I
am stuck here
Please let me know How to make the sheet index name same as the sheet
name after inserting sheets? Thanks
|