Creating a new sheet with date in the sheet name

**hermoraunio** · 07-23-2013, 07:13 AM

Please Login or Register  to view this content.

This works just fine when I create first copy, but after that it's type mismatch (error 13)

EDIT: As this is my first post here, I forgot to explain what I want to do here.
I want to create a new sheet with a name "24.7.2013" if the previous date was "23.7.2013" and so on.
Every H11 Cell in every sheet contains a date. I am setting the variable ShtName a value (the date from newest sheet cell H11 + 1).
Then I copy the newest sheet and rename it with ShtName. Sorry if this seems messy. It's actually quite simple, I'm just not so good at explaining stuff.

**Solus Rankin** · 07-23-2013, 08:32 AM

So you run this every time you want to add a day and count up inserting the newest day in between the first day and the last day added?

Is that the outcome you actually want?

**hermoraunio** · 07-24-2013, 01:04 AM

Well, the optimal outcome would be:

1. New sheet name is today in form of "dd.mm weekday"
2. New sheet would appear on the left side of the main page [before:sheets(1)]
2.1 Sheet 4 (oldest) - Sheet3 (older) - Sheet 2 (old) - Sheet 1 (newest) - Main Page
3. If today already exists, macro would prompt new date with an InputBox and then form new sheet with that data

I guess this whole thing could be done way differently and more logically, but I'm actually not that great with VBA.