VBA to automatically create A workbook with # of Sheets

[thardin]

I want to write a macro that will automatically create a Workbook with a specific number of sheets based on the amount of days in the current month(one worksheet for each day of the month).
With the worksheets named 1st, 2nd, 3rd, etc.

How would you do this?

 

[Fluff]

You're welcome & thanks for the feedback.

 

[thardin]

You're welcome & thanks for the feedback.

Actually, I just noticed that there's this extra worksheet at the end:
How do you prevent this?

 

[thardin]

Actually, I just noticed that there's this extra worksheet at the end:
How do you prevent this?
View attachment 54504

OOPS, NEVERMIND.

that was the wrong file. sorry.
yours was correct!