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