Macros to name sheet with date

[sharonll]

Hi

i have 32 sheets/tabs with data. every month, i have to rename each sheet/tab e.g. Jun 1, Jun 2... Jun 30. the following month, they ll be renamed Jul 1, Jul 2 ... Jul 31.

is there a macro to do this? codes i have seen referenced a cell in each sheet but the data in my sheets don't contain the dates(i.e. Jun 1 ).

[:) Sixthsense :)]

Try the below code.....

Please Login or Register  to view this content.

[sharonll]

It works! Thank you so much

Would it be possible to add the day as well? e.g. Sat Jun 1, Sun Jun 2

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

Replace this line

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[sharonll]

I made the changes, didn't quite work. The sheets took the day of the first sheet.

i.e.
Sat Jun 1, Sat Jun 2, Sat Jun 3, Sat Jun 4 etc.

[:) Sixthsense :)]

Regret for the inconvenience...

Try this revised code...

Please Login or Register  to view this content.

[sharonll]

Works!! Thank you!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback