I want to insert a new sheet and name it "ABC":
Sheets.Add
Sheets("Sheet1").Name = "ABC"
This is fine for the first time as it inserts a new sheet called "Sheet1".
However the next time I do it the newly inserted sheet is called "Sheet2",
but the code is still looking for a "Sheet1".
Can I do something simple like:
Sheets.Add.Name = "ABC"
Thanks in advance.
Bookmarks