macro to insert sheets with input box (DATE)

[excelhelpseeker]

Hi Champs,

This is a scenario...

i need a macro to input my month and year and then respective day names has to be created in sheet names.


for example, if i input December 2014,

31 sheets to be created with Dec 1, Dec2, .......till......Dec 31.

Please help ...

[Norie]

Perhaps.

Please Login or Register  to view this content.

[excelhelpseeker]

the above code works fine only for January 2014... is it possible to make all the month's date ?

[Norie]

Not sure what you mean, the code works fine for me for other months, for example December 2014, Nov 78, July 83 etc.

[excelhelpseeker]

ooopsssssss.. sorry . i was using 03/2014 instead of march/2014.

its working great

[Norie]

That's more kind of my fault, I should have accounted for people entering the month/date in a different format, or at least indicate the required format for the code to work properly.

I would do that now but I'm using a version of the code to see how Excel handles the addition of a sheet for every day in every year in a decade.

[excelhelpseeker]

Thanks a lot NORIE.