Sheet name in cell not working

[Lukael]

Hi,

take a look at sample worksheet, and click on the button "months". It will generate moths, and It should also insert sheets name in B13 cell. That is also good, but It should enter all names in upper case to that cell, in each sheet - but It doesn't. WHY ??

[HaHoBe]

Hi, Lukael,

because your sheet Name is converted to a date which will be put into the cell (and will format ain proper writing).

Change the code to read

Please Login or Register  to view this content.

and try again.

Or use

Please Login or Register  to view this content.

Ciao,
Holger

[Lukael]

hi Hahobe,

thanks for response, i tried your code but It's still not working !

[HaHoBe]

Hi, Lukale,

as I edited my post while you are answering (there is no preview available when editing posts) may I asked if your tried any of the updated codes or the very first one?

Ciao,
Holger

[Winon]

@ HaHoBe,

Hi Holger,

The very first one, as refered to in your Post above, works perfectly! You deserve a Rep for that from Lukale.

Regards.

[Lukael]

Hi hahobe,

no harm meaning, looks like i read too quickly

only second code works :

Please Login or Register  to view this content.

thanks a LOT !!!

[Lukael]

Don't worry,

Rep was ofcourse given

But strangly, first one didn't work for me...

@ HaHoBe,

Hi Holger,

The very first one, as refered to in your Post above, works perfectly! You deserve a Rep for that from Lukale.

Regards.