Renaming Sheets with present month, all dates of that particular month

Hi All,

I have a worksheet with 30-40 sheets/tabs where I want to rename the sheets with present month, all dates & format to be maintained is mmmdd i.e., Sheet1 as Sep01, Sheet2 as Sep02 etc upto Sheet28 as Sep28

Please provide me a VB code and do the needful.

Regards
Anil T

What do you want to happen when you reach Sep30, if you have more than 30 sheets?

As min days we have are 28 in Feb (I'll run this code every month), I thought to have sheet name to be renamed upto 28, next 2-3 sheets upto eom I can manage by editing manually

I just want code to be implemented upto 28 only, next sheets can be left as it is.

Maybe:

Please Login or Register  to view this content.

Thanks Buddy..Its success now

You're welcome. Glad to help out and thanks for the feedback.