Problem inserting new worksheet in Excel daily time tracker w/ at specific location

I have the following code:

Please Login or Register  to view this content.

My file is used for daily productivity & time tracking and is almost working as I'd like. Originally the macro would place the new sheet to the far right of all sheets in the book, but as it's iterated over the last month or so it's getting cumbersome to keep scrolling all the way to the left to the tab with my macro button ("Activities & Macro"). So, I started tinkering with a new file in which only 3 tabs to start: "Template", "Activities & Macro", and "08-05-20".

When I run the macro a new sheet is created right after the Activities & Macro tab as I'd like (this would mitigate the need to keep scrolling left after a new day/date tab is inserted). However, then there's a break down ... Tab 08-05-20 gets renamed as 08-06-20 and the new sheet (inserted after Activities & Macro tab) is named 08-06-20 (2).

If I run macro again I end up with: 08-07-20 (2), 08-06-20, and 08-07-20 so now what was 08-06-20 is now 08-07-20 and the new sheet is 08-07-20 (2). This would iterate perpetually with every new sheet as a duplicate. Also, once the date is set - it should be static; e.g., first date = 08-05-20, next = 08-06-20, next = 08-07-20 so on for time tracking purposes ...

What am I missing? Thanks!

So you don't want to set wshL to last worksheet. But the worksheet to right of "Activities & Macro" sheet.

Try...

Please Login or Register  to view this content.

That means wshL.Name isn't in format that can be converted using Datevalue.

Use Debug.Print or other means to see what wshL. Name is. Then either rename the sheet or change sheet order. If you cannot fix, upload sample workbook.